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 “chillier” 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.

235 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
chillier1332842(None) 
childlier1543091childlier
chiller124112181chill_er
chillies134113481chillies
hillier103413961_hillier
chalkier1736752chalkier
challie124012852challie_
challies133915642challies
chichier1836022chichier
chilies124218302chi_lies
chilled133310932chill_ed
chillers133710922chill_ers
chilli114312772chilli__
chilliest14358912chilliest
chillily1644112chillily
chilling143512182chilling
chillis124411602chilli_s
chinkier17377362chinkier
chippier17297672chippier
chirpier15276302chirpier
collier93618152c_ollier
frillier1136512frillier
ghillie11326352ghillie_
ghillies12408662ghillies
hiller94421632_hill_er
millier93716702_millier
schiller13296472schill_er
shellier1138392shellier
sillier74017592_sillier
stillier868822stillier
whirlier14175292whirlier
achillea1344103achill_ea
bilgier10358533_bilgier
biller84923483_bill_er
billie85019173_billie_
billies93923503_billies
bullier94116433_bullier
caller85125483c_all_er
calliper1247513c_alliper
cavalier1348173cavalier
caviller1337063cavill_er
ceiler84013963cei_l_er
chaffier1935473chaffier
challis124613463challi_s
challises14358783challises
chancier1538823chancier
charier124317903ch_arier
charlie123011923charlie_
charlies133414233charlies
charrier1378683charrier
chattier1337513chattier
cheekier1735103cheekier
cheerier1348003cheerier
cheesier1335963cheesier
chertier1387873chertier
chestier1387423chestier
chevalier1743613chevalier
chewier1537593ch_ewier
chicaner1586073chicaner
chicer134513603chi__cer
chicle134312543chicl_e_
chicles143512503chicl_es
chider125116053chi__der
chiefer1536863chi_efer
chigger1436003chi_gger
childbed1742883childbed
childe124711213chi_lde_
childes134211273chi_ldes
childing15288503childing
childish1744393childish
childliest1653863childliest
childlike1942983childlike
children1474703children
chile105626893chi_l_e_
chiles115425303chi_l_es
chili106218483chi_li__
chiliad1337563chi_liad
chilis115517873chi_li_s
chill105619873chill___
chillest13259593chillest
chilliness1555313chilliness
chillness1455373chillness
chills114717703chill__s
chillum1435443chill_um
chillums1544163chillums
chilly144113223chill__y
chimblies1845033chimblies
chimer135517203chi__mer
chimley1785163chiml_ey
chinchier1944633chinchier
chintzier2342663chintzier
chipper163912583chi_pper
chippie16297693chippie_
chippies17309753chippies
chirker16429323chi_rker
chirper14359963chi_rper
chiseler1335903chiseler
chiseller1443963chiseller
chitlin12269283chitli_n
chitling142910663chitling
chitlins13289393chitlins
chitter124112963chi_tter
chitties13310773chitties
chivied16368383chi_vied
chivies153412853chi_vies
chivvied2052523chivvied
chivvies1954423chivvies
chokier1638043ch_okier
choler113717153ch_ol_er
choosier1337173choosier
choppier17286643choppier
chromier1538033chromier
chubbier1733893chubbier
chuffier1934543chuffier
chummier1734513chummier
chunkier17395883chunkier
cliffier1633913cliffier
clingier1155853clingier
cliquier1944223cliquier
coalier93416183c_oalier
coiler84421593coi_l_er
collider113410423c_ollider
collie83621993c_ollie_
collied103316673c_ollied
colliers103613583c_olliers
colliery13307363c_olliery
collies94326583c_ollies
comelier12310653comelier
complier14310253complier
costlier1038523costlier
crawlier13216873crawlier
crimpier14287323crimpier
crinklier1543843crinklier
crispier12297253crispier
cruller968753crull_er
cuddlier1234013cuddlier
culler84322253c_ull_er
cullied104012353c_ullied
cullies94419963c_ullies
curlier93314183c_urlier
dallier84215373_dallier
dillies84122163_dillies
driller84311883drill_er
eviller1056673evill_er
filler94623623_fill_er
fillies103420253_fillies
filmier1237503_filmier
friller104111743frill_er
gainlier965673gainlier
giller74519733_gill_er
gillie74816943_gillie_
gillied95512313_gillied
gillies84120963_gillies
girlier8289523_girlier
griller84513353grill_er
grislier935793grislier
guiltier934493guiltier
haulier1059943_haulier
heller93322513_hell_er
hilled104022223_hill_ed
hillers103718733_hill_ers
hilliest113914113_hilliest
hilling113821773_hilling
hilloed113211293_hilloed
hilloes103815963_hilloes
hinkier143610793_hinkier
hippier143212103_hippier
hissier103410503_hissier
holier94921623_h_olier
holler93520613_holl_er
hollies103420813_hollies
hulkier14328973_hulkier
huller93919103_hull_er
iller54821293__ill_er
inlier63615363__inlier
jollier142911003_jollier
killer104917953_kill_er
killie104114893_killie_
killies113318113_killies
milkier133411163_milkier
miller84625413_mill_er
milliers102611903_milliers
milliner102811863_milliner
miltier93214963_miltier
oilier64417233_oi_lier
pallier94417163_pallier
philter12108213phi_lter
rallier73816273_rallier
roilier7311523roi_lier
sallier73320423_sallier
schillers14285663schill_ers
schilling15286393schilling
schizier2234063schi_zier
schizzier2242253schizzier
shalier103116423sh_alier
sheller103515883shell_er
shelvier1464913shelvier
shielder1235183shielder
shiftier1436343shiftier
shilled113313623shill_ed
shilling123315383shilling
shinier104113143shi_nier
shirtier1137943shirtier
shittier1137313shittier
shoalier1137073shoalier
shriller1136823shrill_er
silkier114411643_silkier
siller64026063_sill_er
sillies73425083_sillies
siltier73413863_siltier
smellier1036793smellier
spiller92914333spill_er
stiller73414293still_er
swiller103211663swill_er
swirlier1135213swirlier
tallier72817213_tallier
thistlier1243653thistlier
thriller1165553thrill_er
tiller64222543_till_er
triller74215893trill_er
twirlier1133513twirlier
whelkier1833253whelkier
whinier134110633whi_nier
whinnier14255003whinnier
whippier18265823whippier
whirler13307603whirl_er
whirlies14167373whirlies
whitier133311063whi_tier
whizzier2233283whizzier
wilier93217073_wi_lier
willer94021063_will_er
willie94116453_willie_
willied114611563_willied
willies103920153_willies
woollier1155433woollier

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622357.14020470.9
3Display Results2352350.1102136.4
 (SQL Overall)1786912357.65623340.0
 
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.