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

273 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
chillies13411348(None) 
challies133915641challies
chilies124218301chi_lies
chillier13328421chillier
chilliest14358911chilliest
chillis124411601chilli_s
ghillies12408661ghillies
billies93923502_billies
challie124012852challie_
challis124613462challi_s
challises14358782challises
charlies133414232charlies
chicles143512502chicl_es
childes134211272chi_ldes
childlier1543092childlier
childliest1653862childliest
chiles115425302chi_l_es
chilis115517872chi_li_s
chilled133310932chill_ed
chiller124112182chill_er
chillers133710922chillers
chillest13259592chill_est
chilli114312772chilli__
chillily1644112chillily
chilliness1555312chilliness
chilling143512182chilling
chillness1455372chillness
chills114717702chill__s
chillums1544162chillums
chimblies1845032chimblies
chippies17309752chippies
chitlins13289392chitlins
chitties13310772chitties
chivies153412852chi_vies
chivvies1954422chivvies
collies94326582c_ollies
cullies94419962c_ullies
dillies84122162_dillies
fillies103420252_fillies
ghillie11326352ghillie_
gillies84120962_gillies
hillier103413962_hillier
hilliest113914112_hilliest
hilloes103815962_hilloes
hollies103420812_hollies
killies113318112_killies
sillies73425082_sillies
whirlies14167372whirlies
willies103920152_willies
achillea1344103achill_ea
achilleas1443263achilleas
allies63827673__allies
aphyllies1743813aphyllies
bailies94120203bai_lies
ballies93725743_ballies
bellies94023723_bellies
bhisties1339003bhisties
bialies93618413_bialies
bilbies114712343_bilbies
billie85019173_billie_
brollies1039533brollies
bullies94121893_bullies
callees94117783c_allees
cavallies1446393cavallies
ceilis85413743cei_li_s
chablis14368563chabli_s
chalcids1635893chalcids
chalices15310813chalices
chalkier1736753chalkier
chalkiest1837083chalkiest
challahs16377563challahs
challas124414123chall_as
chalones13312173chalones
chammies172910163chammies
chanties132615803chanties
chappies172610093chappies
charlie123011923charlie_
cheapies1539033cheapies
chelates132713843chelates
cheloids1438033cheloids
chenilles1444373chenill_es
cherries131812983cherries
chevies153511443ch_evies
chiauses1336483chiauses
chicanes1559373chicanes
chichier1836023chichier
chichiest1936343chichiest
chichis1737073chichi_s
chickees19258513chickees
chicle134312543chicl_e_
chicories1688763chicories
chides124620473chi__des
chields13507483chiel_ds
chiels115115933chiel__s
chigoes1338353chi_goes
chilblains1793513chilblains
childbed1742883childbed
childbeds1841723childbeds
childe124711213chi_lde_
childing15288503childing
childish1744393childish
childless1543813childless
childlike1942983childlike
children1474703children
chile105626893chi_l_e_
chili106218483chi_li__
chiliad1337563chi_liad
chiliads1445853chiliads
chiliasm15134513chi_liasm
chiliast13117933chi_liast
chill105619873chill___
chillum1435443chill_um
chilly144113223chill__y
chimeres153511313chimeres
chimes134922573chi__mes
chimlas1437453chiml_as
chimley1785163chiml_ey
chimleys1883633chimleys
chinches18369363chinches
chines115029173chi__nes
chinkier17377363chinkier
chinkiest1867023chinkiest
chinless1337493chinless
chinones13510473chinones
chintses1337113chintses
chintzes2235973chintzes
chippie16297693chippie_
chippier17297673chippier
chippiest18256803chippiest
chirpier15276303chirpier
chirpiest16286473chirpiest
chirres123812253chi_rres
chitins122713793chi_tins
chitlin12269283chitli_n
chitling142910663chitling
chitlings15255903chitlings
chivalries1843963chivalries
chivaries1757433chivaries
chives144317593chi__ves
chivied16368383chi_vied
chivvied2052523chivvied
cholates132414763cholates
cholines132214493cholines
chollas123811353choll_as
christies1449263christies
chuckies1937703chuckies
chyles144813283ch_yl_es
cicelies1269753cicelies
cilices113814023c_ilices
cissies94116153c_issies
cities84524853c_i_ties
civies114116443c_i_vies
civvies1555843c_ivvies
colies84837053c__olies
collides113214473c_ollides
collie83621993c_ollie_
collied103316673c_ollied
collier93618153c_ollier
colliers103613583c_olliers
collins93419833c_ollins
complies14314523complies
coolies93824963c_oolies
cullied104012353c_ullied
cullis84115993c_ulli_s
cullises103111313c_ullises
dailies84219263dai_lies
dallies84023193_dallies
dellies83622213_dellies
dhoolies1246963dhoolies
doilies84017363doi_lies
dollies83620983_dollies
echelles1346673echell_es
failles102914133faill_es
fellies104119743_fellies
filles94224523_fill_es
fillips12298133_fillips
follies103618943_follies
frillier1136513frillier
frilliest1237113frilliest
gallies84122713_gallies
ghiblis1353343ghibli_s
ghoulies1235393ghoulies
gillie74816943_gillie_
gillied95512313_gillied
girlies83013703_girlies
grilles83715023grill_es
gullies84717313_gullies
halloes104021523_halloes
helloes103717463_helloes
hickies163614743_hickies
hilled104022223_hill_ed
hiller94421633_hill_er
hillers103718733_hillers
hilliness1248923_hilliness
hilling113821773_hilling
hilloas104413553_hilloas
hilloed113211293_hilloed
hillos94618893_hill_os
hills85431353_hill__s
hillsides1344553_hillsides
hinnies103615103_hinnies
hiplines13310593_hiplines
hippies142813743_hippies
hissies103915823_hissies
holies94630033_h_olies
holloes103818193_holloes
hulloes104113923_hulloes
hurlies103315333_hurlies
illites72415013__illites
jellies143816533_jellies
jollies143516273_jollies
kellies113516853_kellies
killie104114893_killie_
kilties113014143_kilties
lilies63021413_li_lies
lollies73116923_lollies
milles84526563_mill_es
millier93716703_millier
milliers102611903_milliers
millimes122411373_millimes
millines102718063_millines
mislies92922283_mislies
mollies93420233_mollies
nellies73418723_nellies
philtres1396513philtres
phyllites1745323phyllites
rallies73823343_rallies
ramillies1146133ramillies
rilles64725503_rill_es
sallies73227813_sallies
schiller13296473schill_er
schillers14285663schillers
schilling15286393schilling
schillings16243273schillings
shellier1138393shellier
shelliest1238023shelliest
shelties111111383shelties
shilled113313623shill_ed
shilling123315383shilling
shillings13348093shillings
shills94519613shill__s
shimmies15287803shimmies
shindies122610503shindies
shinnies113010913shinnies
silkies113715693_silkies
sillier74017593_sillier
silliest84017103_silliest
stillier868823stillier
stilliest939223stilliest
sullies74122233_sullies
tailles72516473taill_es
tallies73624603_tallies
tellies73820503_tellies
thills95515383thill__s
thirties1139723thirties
tillites8312833_tillites
trilbies1037693trilbies
trollies8310233trollies
tuilles72411923tuill_es
wallies103320743_wallies
wellies103719073_wellies
wheelies1437863wheelies
whiles124418013whi_l_es
whimsies1635193whimsies
whinnies14237273whinnies
whirlier14175293whirlier
whirliest15216043whirliest
whirries14136693whirries
whiskies1835953whiskies
whities133113253whi_ties
willie94116453_willie_
willied114611563_willied
woollies1147413woollies

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.420425454.8
2DLD Change Limit1461622737.15620425.1
3Display Results2732730.1102481.8
 (SQL Overall)1786912737.68623248.9
 
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.