Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “atelier” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

387 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
atelier731162(None) 
ateliers837881ateliers
aerier64823152a_erier
applier1137902applier
atelic8313702ateli_c
belier84423562_belier
eelier64216462_eelier
gaselier946962gaselier
hotelier1137632hotelier
relier65826182_relier
statelier945652statelier
steelier839192steelier
tallier72817212tallier
telfer9379892_telfer
teller63519822_teller
waterier11312082waterier
abele76323253abel_e_
abeles84719393abel_es
abelia83114403abeli_a
abelian92810643abelian
abelias93213563abelias
abetter958323abetter
abler75624313a_bl_er
acerber1135243acerber
achier113914263a_chier
adepter1036113adepter
aerie54634603a_erie_
aeried74221863a_eried
aeries64737783a_eries
aether94213673a_ether
airier64619363a_irier
airliner836953airliner
alder65421913a__lder
alerter72111513alerter
alien56425583a__lien
aliner65621983a__liner
alleger8319633alleger
allied74217153a_llied
allies63827673a_llies
alter54828503a__lter
alterer72714003alte_rer
ambler104916453ambl_er
ameer75618983ame__er
amender10349613amender
amercer1146373amercer
ampler104313303ampl_er
anele55628833anel_e_
aneled74719283anel_ed
aneles64626293anel_es
aneling82719503aneling
angler74017863angl_er
angrier839023angrier
anteater8311603anteater
anterior8611053anterior
antilifer1246833antilifer
antler64615553antl_er
antsier7410773antsier
apelike13310533apelike
aperies9423203aperies
applied1247483applied
appliers1235573appliers
applies11311223applies
arteries8321483arteries
artier63419733a_rtier
artsier768943artsier
ashier94714833a_shier
ashler9459973ashl_er
ataxies142410013ataxies
atheling1249203atheling
atomies93918363atomies
atomiser10268153atomiser
atomizer19298533atomizer
atoner64817193at_oner
atonies75320953atonies
atopies92816433atopies
attainer8116913attainer
attemper12103633attemper
attender935913attender
attester836503attester
attire62412383at_tire
aulder7511453a_ulder
auntlier834903auntlier
avenger1135493avenger
averter102410553averter
baseliner1144743baseliner
battier93515713bat_tier
battler94113383battl_er
beefier12329093beefier
beerier93613023beerier
belie75630383_belie_
belied95022163_belied
belief115018603_belief
beliers94617383_beliers
belies84631053_belies
belter84720963_belter
brevier1237763brevier
bullier94116433bullier
burlier93514413burlier
cameleer1246033cameleer
catbrier1236173catbrier
catchier15329863catchier
caterer92815943cate_rer
cattier93317073cat_tier
cavalier1348183cavalier
ceiler84013963_ceiler
chewier1537593chewier
coalier93416183coalier
collier93618153collier
comelier12310653comelier
crepier1139743crepier
curlier93314183curlier
cutesier1045623cutesier
dallier84215373dallier
danglier1056753danglier
darklier1335013darklier
dateline9810353dateline
datelined1194713datelined
datelines1088853datelines
deedier93011593deedier
defier105118653_defier
deliver113312243_deliver
delver104913493_delver
denier74420693_denier
dewier104013463_dewier
dueler74213683duel_er
dueller8329833dueller
dweller11297273dweller
earlier72612743earlier
earthlier1244303earthlier
eateries8324313eateries
eerier64320023_eerier
elder64020023__elder
elmier839813__elmier
elver85216243__elver
eyeliner1174893eyeliner
fattier103513463fat_tier
featlier1136453feat_lier
feeler93215173feel_er
feller94419553_feller
fielder11217413fielder
fierier103511193fierier
flier86023403__flier
fueler94313933fuel_er
fueller10279963fueller
gainlier965673gainlier
ganglier1047603ganglier
gasalier936443gasalier
gaseliers1044923gaseliers
gasolier935833gasolier
gatelike1337933gatelike
geekier12286393geekier
gelder84613713_gelder
girlier8289523girlier
godlier938893godlier
hacklier1737133hacklier
haulier1059943haulier
heeler93917313heel_er
heller93322513_heller
helper114313093_helper
hillier103413963hillier
holier94921623_holier
homelier1338983homelier
hoteliers1245803hoteliers
inlier63615363_inlier
itchier12247673itchier
itemizer19104453itemizer
janglier1656113janglier
jetliner1534853jetliner
jettier14358693jettier
jollier142911003jollier
jowlier17327563jowlier
kelter103214383_kelter
labeler92310183label_er
labeller10248073labeller
lateener835763lateener
lathier10310833lat_hier
lavalier1146043lavalier
leerier73111503leerier
levier94013873_levier
lier45942463___lier
likelier1235283likelier
livelier1136873livelier
lonelier838003lonelier
lovelier1136433lovelier
lowlier10338903lowlier
manlier92414023manlier
marblier1256343marblier
marlier92614773marlier
materiel10311253materiel
matier84321523mat__ier
mealier93015903mealier
melder93915813_melder
melter83520113_melter
metier83517693_metier
millier93716703millier
motlier92010583motlier
nattier73614623nat_tier
needier84010623needier
nettier74211813nettier
nettlier864813nettlier
oilier64417233_oilier
onerier7311613onerier
outlier72216143outlier
palier85023563_palier
pallier94417163pallier
patchier15319663patchier
patellar1046863patellar
peeler83517383peel_er
pelter83321623_pelter
pettier94213613pettier
plier75221283__plier
premier113515633premier
queller16289293queller
querier16310013querier
rallier73816273rallier
rarefier1135353rarefier
ratifier1139673ratifier
rattier74015593rat_tier
rattler74012743rattl_er
raveler104212463ravel_er
raveller11339263raveller
reedier83815303reedier
reefier102912553reefier
reekier113111123reekier
reeler63822573reel_er
relied74926233_relied
relief94419683_relief
reliers75519213_reliers
relies65036423_relies
replier94214973replier
roilier7311523roilier
rulier65016353_rulier
sallier73320423sallier
scalier94316913scalier
seedier83513633seedier
seemlier1035193seemlier
seepier92912013seepier
seller63824603_seller
sexier13310683_sexier
shalier103116423shalier
shapelier1444463shapelier
sheller103515893sheller
shellier1138393shellier
shelter103214963shelter
shelver134211063shelver
shelvier1464913shelvier
sillier74017593sillier
skelter113610003skelter
slier54827243__slier
smeller94212793smeller
smellier1036793smellier
smelter93311913smelter
sneller73512853sneller
speller95415153speller
spelter94113703spelter
stagier83513443stagier
staler64025823stal_er
stalker113912253stalker
stalkier1257073stalkier
steadier937313steadier
stealer72913983stealer
steamer93313093steamer
steamier1048303steamier
steelie7310213steelie_
steelies8312553steelies
steeper93812773steeper
steer55423863ste__er
steerer73113633steerer
stelae63716483stelae_
stelar64013863stel_ar
stele55026843stel_e_
steles63725663stel_es
stelic8313083steli_c
stellar72610433stellar
stemmer113210183stemmer
stemmier1245253stemmier
stepper113010853stepper
sterner7411913sterner
stiller73414303stiller
stillier868823stillier
stolider936603stolider
stonier72013793stonier
studier82510053studier
studlier935473studlier
styler94013303styl_er
styliser11185523styliser
stylizer20185443stylizer
surlier72915443surlier
svelter10359673svelter
sweller103012473sweller
swelter103711173swelter
tackier133712523tackier
tailer63823733tail_er
taler56034863_tal_er
talker103916223_talker
talkier114011843talkier
taller63721963_taller
tallied83314753tallied
talliers83711373talliers
tallies73624603tallies
tangier83013903tangier
tanglier948073tanglier
tardier859719993tardier
tarrier74323173tarrier
tarsier74119253tarsier
tartier74123263tartier
tastier711817093tastier
tattier74216243tattier
tattler73112213tattl_er
tawnier10318463tawnier
tearer64822903_tearer
tearier73815613_tearier
teaser65421523_teaser
techier1269243_techier
tedder83312163_tedder
teemer85515743_teemer
teener64717503_teener
teenier72611143teenier
teeter65420313_teeter
telae54323293_telae_
tele45040873_tel_e_
teles54536003_tel_es
telex125214823_tel_ex
telfers10299073_telfers
telia55821143_teli_a
telial65815363_telial
telic76019823_teli_c
telium82611393_telium
tellers73717603_tellers
tellies73820503_tellies
telnet6518833_telnet
telpher1235563_telpher
temper103914093_temper
tender74121843_tender
tenner64117103_tenner
tenser64919433_tenser
tenter64623933_tenter
tentier73815923_tentier
termer85717253_termer
terrier73414963_terrier
terser67317823_terser
tester64227153_tester
testier74015643_testier
tether93716103_tether
tetter64322453_tetter
thewier1336063thewier
tidier73515113_tidier
tier44936143_t__ier
tiler56131023_til_er
tiller64222543_tiller
tilter63417693_tilter
timelier1036713timelier
tinier63622233_tinier
toiler63918283_toiler
toller63819443_toller
tonier65520713_tonier
trier54328533_t_rier
twier84713293_t_wier
typier1137333_typier
uglier748953_uglier
utiliser855243utiliser
utilizer1756203utilizer
vealier102712173vealier
veiler93814353_veiler
veliger1137313_veliger
verier94620963_verier
viewier1334983viewier
wabblier15375493wabblier
wafflier1733953wafflier
wagglier1344323wagglier
wamblier15275733wamblier
waterer103314073wate_rer
weedier113810623weedier
weenier103210803weenier
weepier12319273weepier
welder102914413_welder
welter93417383_welter
whelkier1833253whelkier
wielder11197673wielder
wieldier1234283wieldier
wifelier1434853wifelier
wilier93217073_wilier
wiselier1137363wiselier
woolier103612353woolier
yeller94214513_yeller
yelper11458783_yelper
yielder11175113yielder

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340273877.37318178.1
3Display Results3873870.1402764.3
 (SQL Overall)1786913877.91922564.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.