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

372 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
challies13391564(None) 
challie124012851challie_
challis124613461challi_s
challises14358781challises
charlies133414231charlies
chillies134113481chillies
allies63827672__allies
ballies93725742_ballies
callees94117782c_allees
cavallies1446392cavallies
chablis14368562chabli_s
chalcids1635892chalcids
chalices15310812chalices
chalkier1736752chalkier
chalkiest1837092chalkiest
challahs16377562challahs
challas124414122chall_as
chalones13312172chalones
chammies172910162chammies
chanties132615802chanties
chappies172610102chappies
charlie123011922charlie_
chilies124218302ch_ilies
chillier13328422chillier
chilliest14358912chilliest
chillis124411602chilli_s
collies94326582c_ollies
cullies94419962c_ullies
dallies84023192_dallies
gallies84122712_gallies
ghillies12408662ghillies
halloes104021522_halloes
hollies103420812_hollies
rallies73823342_rallies
sallies73227812_sallies
tallies73624602_tallies
wallies103320742_wallies
alkies104518093__alkies
allees64521483__allees
allied74217153__allied
aphyllies1743823aphyllies
bailies94120203_bailies
baldies105317703_baldies
bellies94023723_bellies
bialies93618413bia_lies
billies93923503_billies
brollies1039533brollies
bullies94121893_bullies
cabbies133115163c_abbies
cables104527553c_abl_es
caddies113718383c_addies
calces104420053c_a_lces
calcines12314753c_alcines
calcites12313003c_alcites
calices114321693c_alices
califs114915893c_a_lifs
calkins133814873c_alkins
callans94518473c_allans
callas84526753c_all_as
called94126733c_all_ed
callee84327293c_all_ee
caller85125483c_all_er
callers94221963c_allers
callet84536763c_all_et
callets93821703c_allets
calling103826773c_alling
callings113613833c_allings
calliopes1346143c_alliopes
callipee1237733c_allipee
callipees1345303c_allipees
calliper1247513c_alliper
callipers1356493c_allipers
callose9313663c_allose
calloses10313393c_alloses
callous93516603c_allous
calls75634733c_all__s
callus85317073c_all_us
calluses1039323c_alluses
calories102919563c_alories
calques182710193c_alques
calves115119283c_a_lves
calxes154113033c_a_lxes
calyces14428803c_alyces
calyxes19426233c_alyxes
cammies134016483c_ammies
candies104125613c_andies
caplins113515993c_aplins
caries85147623c_a_ries
carles85435083c_arl_es
carlines103521653c_arlines
carlins93921923c_arlins
carnies94123963c_arnies
carries94328013c_arries
catlins93818843c_atlins
catties94023053c_atties
caules85927253c_aul_es
caulis85320083c_auli_s
cavalries1446363cavalries
cavies114525003c_a_vies
chadless1436403chadless
chafes145017913cha__fes
chaffier1935473chaffier
chaffiest2045423chaffiest
chagrins1437073chagrins
chaines124518733cha_ines
chains114819703cha__ins
chairs114916183cha__irs
chais107530313cha__i_s
chaise114916413cha__ise
chaises124317493cha_ises
chalahs15289883cha_lahs
chalazas2245893chalazas
chalcid1537883chalci_d
chaleh143711993cha_l_eh
chalehs15268803cha_lehs
chalet113825993cha_l_et
chalets122813473cha_lets
chalice14311043cha_lice
chaliced1637043chaliced
chalked17449863cha_lked
chalking183310063chalking
chalks155412143cha_l_ks
challa114014193chall__a
challah15458323chall_ah
challenges1643993challenges
challot123613263chall_ot
challoth16316103challoth
chally144314293chall__y
chalone12312103chalone_
chalupas1554383chalupas
chamades16138653chamades
chamise143612853cha_mise
chamises153513313chamises
chammied18215973chammied
chamois143512193chamoi_s
chamoises16327933chamoises
chances145218093cha_nces
chancier1538823chancier
chanciest1638383chanciest
chancres15429363chancres
changes134517583cha_nges
chantries14310293chantries
chaoses124715123cha_oses
chapes135421873cha__pes
chaplains1645743chaplains
chaplet14512253chapl_et
chaplets1556883chaplets
chappie16298663chappie_
charades141310853charades
charases131312763charases
chares115631803cha__res
charges134615983cha_rges
charier124317903cha_rier
chariest13315513cha_riest
charities14312743charities
charladies1644023charladies
charley15118273charl_ey
charleys1695633charleys
charrier1378693charrier
charriest1438263charriest
chases115128233cha__ses
chasses124017503cha_sses
chassis123910663chassi_s
chastise1348173chastise
chastises1437703chastises
chattier1337513chattier
chattiest1448213chattiest
chausses1345963chausses
chayotes1636503chayotes
cheapies1539033cheapies
chelates132713853chelates
cheloids1438033cheloids
cherries131812993cherries
chevies153511443ch_evies
chicles143512503chicl_es
childes134211273ch_ildes
childlier1543093childlier
childliest1653863childliest
chiles115425303ch_il_es
chilis115517873ch_ili_s
chilled133310933chill_ed
chiller124112183chill_er
chillers133710923chillers
chillest13259593chill_est
chilli114312773chilli__
chillily1644113chillily
chilliness1555313chilliness
chilling143512183chilling
chillness1455373chillness
chills114717703chill__s
chillums1544163chillums
chimblies1845033chimblies
chippies17309763chippies
chitlins13289393chitlins
chitties13310773chitties
chivalries1843963chivalries
chivies153412853ch_ivies
chivvies1954423chivvies
cholates132414763cholates
cholines132214493cholines
chollas123811353choll_as
chuckies1937703chuckies
chyles144813283ch_yl_es
cicelies1269753cicelies
claries93422203cla_ries
coalbins1237083coalbins
coalier93416183coa_lier
coaliest10316223coa_liest
coalifies1439113coalifies
coalless1038193coalless
coalpits1245403coalpits
colies84837053c__olies
collides113214473c_ollides
collie83621993c_ollie_
collied103316683c_ollied
collier93618153c_ollier
colliers103613583c_olliers
collins93419833c_ollins
complies14314523complies
coolies93824963c_oolies
corallines1246553corallines
coxalgies1943243coxalgies
cradles103114133cradl_es
crannies10313013crannies
crappies142911173crappies
crawlier13216873crawlier
crawliest14187403crawliest
crazies183413853cra_zies
cullied104012353c_ullied
cullis84115993c_ulli_s
cullises103111313c_ullises
dailies84219263_dailies
dalles74222063_dall_es
dallied93713613_dallied
dallier84215373_dallier
dalliers93610613_dalliers
dellies83622213_dellies
dhoolies1246963dhoolies
dillies84122163_dillies
dollies83620983_dollies
echelles1346673echell_es
falsies103515013_falsies
fealties1139993fealties
fellies104119743_fellies
fillies103420253_fillies
follies103618943_follies
gallied94115003_gallied
gharries12318223gharries
ghazies2036913gha_zies
ghillie11326353ghillie_
ghoulies1235393ghoulies
gillies84120963_gillies
goalies8316023goa_lies
gullies84717313_gullies
hackies163418243_hackies
hales85449843_ha_l_es
halflives1842783_halflives
halides113416663_halides
halids104016133_ha_lids
halites103221193_halites
hallahs133912463_hallahs
hallel93514093_hall_el
hallels103310133_hallels
halloas104318463_halloas
halloed113314913_halloed
halloos103716743_halloos
hallos95425103_hall_os
hallows134417393_hallows
halls85633783_hall__s
halluces1335613_halluces
haloes94623863_ha_loes
haloids113012553_haloids
halves124717093_ha_lves
hankies143617763_hankies
haoles94919803_haol_es
haplites1339993_haplites
hardies114923233_hardies
harpies123818323_harpies
harries103525503_harries
haulier1059943_haulier
hauliers1176713_hauliers
hawkies173311243_hawkies
helloes103717473_helloes
hillier103413963_hillier
hilliest113914113_hilliest
hilloes103815963_hilloes
holies94630033_h_olies
holloes103818193_holloes
hulloes104113923_hulloes
hurlies103315333_hurlies
jellies143816533_jellies
jollies143516273_jollies
kellies113516853_kellies
khalifs1754073kha_lifs
killies113318113_killies
lealties8310793lealties
lollies73116923_lollies
mallees93315973_mallees
mealies92821933mea_lies
misallies1148383misallies
mollies93420233_mollies
nellies73418723_nellies
otalgies936393otalgies
pallier94417163_pallier
palliest102814643_palliest
palsies94420273_palsies
phalli1148263phalli__
phallic1447293phalli_c
phallism1545713phallism
phallisms1645073phallisms
phallist1338993phallist
phallists1445723phallists
phallus1236063phall_us
phalluses1444263phalluses
phyllites1745323phyllites
rallied83514083_rallied
rallier73816273_rallier
ralliers84010833_ralliers
rallyes10348553_rallyes
realties8514853realties
retallies939373retallies
sallied83316953_sallied
sallier73320423_sallier
salliers83613343_salliers
salties73725773_salties
shadflies1643833shadflies
shales94731253sha_l_es
shalier103116423sha_lier
shaliest111415063sha_liest
shallops13288323shallops
shallots11319503shallots
shallows14388863shallows
shammies15259693shammies
shandies122714113shandies
shannies113411263shannies
shanties113116593shanties
sharpies13411233sharpies
shasliks1544143shasliks
shavies134213213sha_vies
shellier1138393shellier
shelliest1238033shelliest
shelties111111383shelties
sillies73425083_sillies
sullies74122233_sullies
talkies113415733_talkies
tallied83314753_tallied
tallier72817213_tallier
talliers83711373_talliers
tallis63319963_talli_s
tallises82713263_tallises
tallits73215993_tallits
tellies73820503_tellies
thalli958923thalli__
thallic1246553thalli_c
thallious1243273thallious
thallium1344433thallium
thalliums1443253thalliums
thallous1136523thallous
thallus1035603thall_us
thalluses1243903thalluses
trollies8310233trollies
unallied938393unallied
walies95324523_wa_lies
wallie93216803_wallie_
wellies103719073_wellies
whales124716943wha_l_es
whammies18265513whammies
wheelies1437873wheelies
whirlies14167373whirlies
willies103920153_willies
woollies1147413woollies
yearlies1137603yearlies

Search took 9 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 Limit1461623727.87318565.0
3Display Results3723720.1402657.1
 (SQL Overall)1786913728.41921224.7
 
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.