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

294 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
challie12401285(None) 
challies133915641challies
challis124613461challis
charlie123011921charlie
callee84327292c_allee
chablis14368562chablis
chalcid1537882chalcid
chalice14311042chalice
chalkier1736752chalkier
challa114014192chall_a
challah15458322challah
challas124414122challas
challises14358782challises
challot123613262challot
chally144314292chall_y
chalone12312102chalone
chappie16298662chappie
charlies133414232charlies
chilli114312772chilli_
chillier13328422chillier
chillies134113482chillies
chillis124411602chillis
collie83621992c_ollie
ghillie11326352ghillie
phalli1148262phalli_
phallic1447292phallic
thalli958922thalli_
thallic1246552thallic
wallie93216802_wallie
alkie95520033__alkie
allee54932123__allee
allied74217153__allied
allies63827673__allies
bailie83818363_bailie
ballies93725743_ballies
billie85019173_billie
brawlie12198153brawlie
cabbie122913353c_abbie
cable95329913c_abl_e
caddie104316453c_addie
calcic9311873c_alcic
calcine11315273c_alcine
calcite11413783c_alcite
calflike1735153c_alflike
calif104929103c_a_lif
calix145317353c_a_lix
calkin123515493c_alkin
call66838673c_all__
calla74827073c_all_a
callan83619603c_allan
callas84526753c_allas
called94126733c_alled
callees94117783c_allees
caller85125483c_aller
callet84536763c_allet
calling103826773c_alling
calliope1256223c_alliope
callipee1237733c_allipee
calliper1247513c_alliper
callose9313663c_allose
callow114714663c_allow
calls75634733c_all_s
callus85317073c_allus
calorie92716903c_alorie
calque17289843c_alque
calve105919923c_a_lve
cammie124615293c_ammie
cannie83819363c_annie
caplin103216303c_aplin
carle74535703c_arl_e
carlin84421823c_arlin
carline93923613c_arline
carnie84421093c_arnie
catlike132712933c_atlike
catlin83819083c_atlin
cattie85221023c_attie
cauline92215603c_auline
caulis85320083c_aulis
cavallies1446393cavallies
cavie104621593c_a_vie
cellae84915933c_ellae
celli76717693c_elli_
chadri1238143chadri_
chaetae1238603chaetae
chafe135117353cha__fe
chaffier1935473chaffier
chagrin1337893chagrin
chai95929903cha__i_
chain105723673cha__in
chaine115119223cha_ine
chair105519633cha__ir
chais107530313cha__is
chaise114916413cha_ise
chalah143511663cha_lah
chalahs15289883chalahs
chalaza2145733chalaza
chalazae2244423chalazae
chalazia2245133chalazia
chalcids1635893chalcids
chaleh143711993cha_leh
chalehs15268803chalehs
chalet113825993cha_let
chalets122813473chalets
chaliced1637043chaliced
chalices15310813chalices
chalk144814603cha_l_k
chalked17449863chalked
chalkiest1837093chalkiest
chalking183310063chalking
chalks155412143cha_lks
chalky18468773cha_lky
challahs16377563challahs
challenge1543623challenge
challoth16316103challoth
chalones13312173chalones
chalot113020133cha_lot
chaloth15298603chaloth
chalupa1444473chalupa
chalutz2195093chalutz
chamade15138453chamade
chamise143612853chamise
chammied18215973chammied
chammies172910163chammies
chamois143512193chamois
chamoix21275643chamoix
chance134617093cha_nce
chancier1538823chancier
chancre14348783chancre
change124116753cha_nge
chanties132615803chanties
chaotic14310043chaotic
chape125221143cha__pe
chaplain1546193chaplain
chaplet14512253chaplet
chappies172610103chappies
charade13129913charade
chare105231983cha__re
charge125114213cha_rge
charier124317903cha_rier
charily15310283charily
charley15118273charley
charrier1378683charrier
chase105127123cha__se
chasmic16177983chasmic
chasse115114603cha_sse
chassis123910663chassis
chaste114617393cha_ste
chastise1348173chastise
chattier1337513chattier
chayote1536493chayote
cheapie1437563cheapie
chelae113614603ch_elae
chelate122914893chelate
cheloid13310833cheloid
chicle134312543chicl_e
childe124711213ch_ilde
childlier1543093childlier
childlike1942983childlike
chile105626893ch_il_e
chili106218483ch_ili_
chilies124218303ch_ilies
chilis115517873ch_ilis
chill105619873chill__
chilled133310933chilled
chiller124112183chiller
chilliest14358913chilliest
chillily1644113chillily
chilling143512183chilling
chills114717703chill_s
chillum1435443chillum
chilly144113223chill_y
chippie16297693chippie
chitlin12269283chitlin
cholate122114933cholate
choline122915383choline
cholla113911023choll_a
chollas123811353chollas
chyle134913483ch_yl_e
clamlike1635163clamlike
clawlike1733913clawlike
claylike1734463claylike
coalbin1137533coalbin
coalier93416183coa_lier
coalpit1148513coalpit
collide103214793c_ollide
collied103316673c_ollied
collier93618153c_ollier
collies94326583c_ollies
coolie83821603c_oolie
coralline1147943coralline
crablike1636023crablike
cradle93313163cradl_e
crappie13298983crappie
crawlier13216873crawlier
cullied104012353c_ullied
cullies94419963c_ullies
cullis84115993c_ullis
dallied93713613_dallied
dallier84215373_dallier
dallies84023193_dallies
echelle1246623echell_e
falsie93513853_falsie
gallic9411643_gallic
gallied94115003_gallied
gallies84122713_gallies
ghillies12408663ghillies
ghoulie1144263ghoulie
gillie74816943_gillie
goalie7413163goa_lie
habile11515213_habile
hackie154615623_hackie
hale76052833_ha_l_e
halflife1743213_halflife
halid94424983_ha_lid
halide103417993_halide
halite93624233_halite
hall75741163_hall__
hallah124115403_hallah
hallal94415563_hallal
hallel93514093_hallel
hallo85127553_hall_o
halloa94918123_halloa
halloed113314913_halloed
halloes104021523_halloes
halloo95118973_halloo
hallos95425103_hallos
hallot95426783_hallot
hallow124818323_hallow
halls85633783_hall_s
hallux1637363_hallux
haloid104317763_haloid
halolike1537403_halolike
halve114818923_ha_lve
hankie133915713_hankie
haole84820083_haol_e
haplite12310703_haplite
hatlike143311713_hatlike
haulier1059943_haulier
hawkie163810093_hawkie
hillier103413963_hillier
hollies103420813_hollies
hoolie93217783_hoolie
khalif1657833kha_lif
killie104114893_killie
mallee84525593_mallee
mallei84414633_mallei
mealie82519813mea_lie
mollie83517103_mollie
nellie63614813_nellie
pallia83015593_pallia
pallid93915283_pallid
pallier94417163_pallier
phallism1545713phallism
phallist1338993phallist
phallus1236063phallus
phyllite1645743phyllite
rallied83514083_rallied
rallier73816273_rallier
rallies73823343_rallies
ralline73518413_ralline
rallye95110163_rallye
sallied83316953_sallied
sallier73320423_sallier
sallies73227813_sallies
saltie63422433_saltie
seallike12108323seallike
shale85332833sha_l_e
shalelike1645883shalelike
shalier103116423sha_lier
shall85024053shall__
shallop12348453shallop
shallot103614133shallot
shallow13388873shallow
sharpie1238403sharpie
shaslik1444513shaslik
shavie124312423sha_vie
shellier1138393shellier
sheltie10109913sheltie
talkie103914443_talkie
tallied83314753_tallied
tallier72817213_tallier
tallies73624603_tallies
tallis63319963_tallis
tallit63422733_tallit
thallium1344433thallium
thalloid1246283thalloid
thallus1035603thallus
unallied938393unallied
wallies103320743_wallies
wellie92814913_wellie
whale115517433wha_l_e
whalelike1943993whalelike
wheelie1336193wheelie
willie94116453_willie

Search took 7 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.403443402.0
2DLD Change Limit1340272945.97022450.1
3Display Results2942940.0933161.3
 (SQL Overall)1786912946.46627635.5
 
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.