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

393 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
challis12461346(None) 
chablis14368561chablis
challas124414121challas
challie124012851challie
challies133915641challies
chillis124411601chillis
callas84526752c_allas
calls75634732c_all_s
callus85317072c_allus
caulis85320082c_aulis
chais107530312cha__is
chalahs15289882chalahs
chalcid1537882chalcid
chalcids1635892chalcids
chalehs15268802chalehs
chalets122813472chalets
chalks155412142cha_lks
challa114014192chall_a
challah15458322challah
challahs16377562challahs
challises14358782challises
challot123613262challot
chally144314292chall_y
chamois143512192chamois
charlie123011922charlie
charlies133414232charlies
chassis123910662chassis
chilis115517872ch_ilis
chilli114312772chilli_
chillies134113482chillies
chills114717702chill_s
chollas123811352chollas
cullis84115992c_ullis
hallos95425102_hallos
halls85633782_hall_s
phalli1148262phalli_
phallic1447292phallic
phallism1545722phallism
phallist1338992phallist
phallus1236062phallus
tallis63319962_tallis
thalli958922thalli_
thallic1246552thallic
thallus1035602thallus
aaliis6312903_aaliis
allies63827673__allies
alls46740923__all_s
ballies93725743_ballies
balls76236413_ball_s
bhaktis1633433bhaktis
bialis83617163bia_lis
cables104527553c_ables
caddis104613383c_addis
cadis84428503c_a_dis
calces104420053c_alces
calcic9311873c_alcic
calfs104919383c_a_lfs
calif104929103c_a_lif
califs114915893c_alifs
calix145317353c_a_lix
calkin123515493c_alkin
calkins133814873c_alkins
calks115421603c_a_lks
call66838673c_all__
calla74827073c_all_a
callan83619603c_allan
callans94518473c_allans
called94126733c_alled
callee84327293c_allee
callees94117783c_allees
caller85125483c_aller
callers94221963c_allers
callet84536763c_allet
callets93821703c_allets
calling103826773c_alling
callings113613833c_allings
callose9313663c_allose
callous93516603c_allous
callow114714663c_allow
calms95222353c_a_lms
calos74431903c_a_los
calves115119283c_alves
calxes154113033c_alxes
caplin103216303c_aplin
caplins113515993c_aplins
capris10415083c_apris
carles85435083c_arles
carlin84421823c_arlin
carlins93921923c_arlins
carlish12312773c_arlish
carls77037423c_arl_s
cassis84818853c_assis
catlin83819083c_atlin
catlins93818843c_atlins
caulds95512383c_aulds
caules85927253c_aules
caulks125611863c_aulks
cauls75727773c_aul_s
cavallas1366843cavallas
cavallies1446393cavallies
cavils114014393c_avils
ceilis85413743c_eilis
celli76717693c_elli_
cellist9314423c_ellist
cellos84517803c_ellos
cells75428063c_ell_s
chabuks1843733chabuks
chacmas1638003chacmas
chadars1338293chadars
chadless1436403chadless
chadors1338753chadors
chadri1238143chadri_
chads116122233cha__ds
chafers154512743chafers
chafes145017913cha_fes
chaffs17459613cha_ffs
chagrin1337893chagrin
chagrins1437073chagrins
chai95929903cha__i_
chain105723673cha__in
chaines124518733chaines
chains114819703cha_ins
chair105519633cha__ir
chairs114916183cha_irs
chaise114916413cha__ise
chaises124317493chaises
chakras16428503chakras
chalah143511663cha_lah
chalaza2145733chalaza
chalazas2245893chalazas
chalazia2245133chalazia
chaleh143711993cha_leh
chalet113825993cha_let
chalice14311043chalice
chalices15310813chalices
chalk144814603cha_l_k
chalked17449863chalked
chalkier1736753chalkier
chalkiest1837093chalkiest
chalking183310063chalking
chalky18468773cha_lky
challoth16316103challoth
chalone12312103chalone
chalones13312173chalones
chalot113020133cha_lot
chaloth15298603chaloth
chalupa1444473chalupa
chalupas1554383chalupas
chalutz2195093chalutz
chamisa14328853cha_misa
chamise143612853cha_mise
chamiso14348653cha_miso
chammies172910163chammies
chamoix21275643chamoix
champs154915683cha_mps
chams126028503cha__ms
chances145218093chances
changes134517583changes
changs125215373cha_ngs
chanties132615803chanties
chants115020393cha_nts
chaos105622863cha__os
chaoses124715123chaoses
chaotic14310043chaotic
chapatis15127943chapatis
chapels14429153chapels
chapes135421873cha_pes
chaplain1546193chaplain
chaplains1645743chaplains
chaplet14512253chaplet
chaplets1556883chaplets
chappie16298663chappie
chappies172610103chappies
chaps125326063cha__ps
charas114223613cha_ras
chards125119733cha_rds
chares115631803cha_res
charges134615983charges
charily15310283charily
charism14712203cha_rism
charkas164810963charkas
charks155219703cha_rks
charley15118273charley
charleys1695633charleys
charms135218843cha_rms
charpais1536933charpais
charquis2243933charquis
charros124312153charros
charrs115219193cha_rrs
chars105936643cha__rs
chartist131112133chartist
charts115823093cha_rts
chasers123714923chasers
chases115128233cha_ses
chasmic16177983chasmic
chasms135513143cha_sms
chasses124017503chasses
chastise1348173chastise
chats105730093cha__ts
chaunts1267083chaunts
chawers154412053chawers
chaws135022463cha__ws
chays135319743cha__ys
chazans21268123chazans
chelas113817203ch_elas
cheloid13310833cheloid
cheloids1438033cheloids
chiantis1346593chiantis
chichis1737073chichis
chicles143512503chicles
chields13507483chields
chiels115115933chiel_s
childes134211273childes
childish1744393childish
chiles115425303ch_iles
chili106218483ch_ili_
chilies124218303chilies
chill105619873chill__
chilled133310933chilled
chiller124112183chiller
chillers133710923chillers
chillest13259593chillest
chillier13328423chillier
chilliest14358913chilliest
chillily1644113chillily
chilling143512183chilling
chillum1435443chillum
chillums1544163chillums
chilly144113223chill_y
chimlas1437453chimlas
chis95933313ch___is
chitlin12269283chitlin
chitlins13289393chitlins
chlamys1733783chlamys
cholas114818003ch_olas
cholers124215203cholers
cholla113911023choll_a
cholos114716853ch_olos
churlish1644903churlish
churls115411073churl_s
chyles144813283ch_yles
chylous15107273chylous
classis93712723classis
coalas87418963coa_las
coalbin1137533coalbin
coalbins1237083coalbins
coalers94419353coalers
coalfish1635493coalfish
coalless1038193coalless
coalpit1148513coalpit
coalpits1245403coalpits
coals76129603coa_l_s
coatis85122603coa_tis
collie83621993c_ollie
collies94326583c_ollies
collins93419833c_ollins
coulis84018763c_oulis
craals84113303craal_s
cradles103114133cradles
crasis85020473cra_sis
crawls114712083crawl_s
cullies94419963c_ullies
culls75425813c_ull_s
dalles74222063_dalles
dallies84023193_dallies
dhals95415443dha_l_s
diallist949553diallist
echelles1346673echelles
falls85727653_fall_s
follis93113903_follis
gallic9411643_gallic
gallies84122713_gallies
galls64729323_gall_s
gallus74313203_gallus
gharris11306433gharris
ghazis1935203gha_zis
ghiblis1353343ghiblis
ghillie11326353ghillie
ghillies12408663ghillies
ghylls1335143ghyll_s
hadjis17439653_hadjis
haggis11209513_haggis
hails85231643_hail_s
hajis156716283_ha_jis
hajjis15485893_hajjis
halalas104214083_halalas
halals95018313_halals
halers94926923_halers
hales85449843_ha_les
halid94424983_ha_lid
halids104016133_halids
hall75741163_hall__
hallah124115403_hallah
hallahs133912463_hallahs
hallal94415563_hallal
hallel93514093_hallel
hallels103310133_hallels
hallo85127553_hall_o
halloa94918123_halloa
halloas104318463_halloas
halloes104021523_halloes
halloo95118973_halloo
halloos103716743_halloos
hallot95426783_hallot
hallow124818323_hallow
hallows134417393_hallows
hallux1637363_hallux
halmas117017893_halmas
halms105225213_ha_lms
haloes94623863_haloes
haloid104317763_haloid
haloids113012553_haloids
halons95720713_halons
halos85230253_ha_los
halts85230103_ha_lts
halvas124714173_halvas
halves124717093_halves
haoles94919803_haoles
harls85634503_harl_s
haulms11558503_haulms
hauls86123733_haul_s
hellish13310723_hellish
hellos95321683_hellos
hells85032043_hell_s
hillos94618893_hillos
hills85431353_hill_s
hollas94616903_hollas
hollies103420813_hollies
hollos95320633_hollos
hullos94916293_hullos
hulls84923563_hull_s
khadis1446913kha_dis
khakis1265853kha_kis
khalif1657833kha_lif
khalifs1754073khalifs
lalls55324133_lall_s
malls76233433_mall_s
oxalis1339223oxa_lis
palais8420423_palais
pallia83015603_pallia
pallid93915293_pallid
palls74332563_pall_s
phallisms1645073phallisms
phallists1445723phallists
phasis114614923pha_sis
phyllos1535583phyllos
rallies73823343_rallies
rhachis1555693rhachis
sallies73227813_sallies
salmis8514273_salmis
scalls84218203scall_s
shales94731253sha_les
shall85024053shall__
shallop12348453shallop
shallops13288323shallops
shallot103614133shallot
shallots11319503shallots
shallow13388873shallow
shallows14388863shallows
shaloms1288983shaloms
shamois123210423shamois
shantis103313103shantis
shaslik1444513shaslik
shasliks1544143shasliks
shauls94913113shaul_s
shawls125411973shawl_s
shells94319523shell_s
shills94519613shill_s
smallish1346573smallish
smalls84514123small_s
spalls84217343spall_s
stalls64019933stall_s
tallies73624603_tallies
tallish103313583_tallish
tallit63422733_tallit
tallits73215993_tallits
talls55133433_tall_s
thalers106212263thalers
thallious1243273thallious
thallium1344433thallium
thalliums1443253thalliums
thalloid1246283thalloid
thallous1136523thallous
thills95515383thill_s
thralls10299043thrall_s
trellis739873trellis
wallas95719393_wallas
wallie93216803_wallie
wallies103320743_wallies
walls85529383_wall_s
whalers13529713whalers
whales124716943wha_les
whatsis1335253whatsis

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 Limit1340273937.03319056.9
3Display Results3933930.1402807.1
 (SQL Overall)1786913937.57923577.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.