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

432 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
challas12441412(None) 
callas84526751c_allas
challa114014191challa_
challah15458321challah
challahs16377561challahs
challis124613461challis
chollas123811351chollas
calla74827072c_alla_
callan83619602c_allan
callans94518472c_allans
calls75634732c_all_s
callus85317072c_allus
cavallas1366842cavallas
chablis14368562chablis
chacmas1638002chacmas
chakras16428502chakras
chalah143511662cha_lah
chalahs15289882chalahs
chalazas2245892chalazas
chalehs15268802chalehs
chalets122813472chalets
chalks155412142cha_lks
challie124012852challie
challies133915642challies
challot123613262challot
chally144314292chall_y
chalupas1554382chalupas
charas114223612cha_ras
charkas164810962charkas
chelas113817202ch_elas
chillis124411602chillis
chills114717702chill_s
chimlas1437452chimlas
cholas114818002ch_olas
cholla113911022cholla_
coalas87418962coa_las
halalas104214082_halalas
halals95018312_halals
hallah124115402_hallah
hallahs133912462_hallahs
hallal94415562_hallal
halloas104318462_halloas
hallos95425102_hallos
halls85633782_hall_s
halmas117017892_halmas
halvas124714172_halvas
hollas94616902_hollas
phallus1236062phallus
thallus1035602thallus
wallas95719392_wallas
achilleas1443263achilleas
acholias1349573acholias
alas46358123__a_las
albas75925393__albas
alfas87219043__alfas
algas65624933__algas
alias55834603__alias
allay85620393__allay
allays94313743__allays
alls46740923__all_s
almas76629773__almas
anlas55626933__anlas
atlas55821583__atlas
axillas14278963axillas
azaleas1636993azaleas
balas76937213_ba_las
ballad94315323_ballad
ballads104212913_ballads
ballast9313993_ballast
balls76236413_ball_s
balsas86417523_balsas
bhaktas1633643bhaktas
bharals1236733bharals
cabalas113516003cabalas
cabals104020153c_abals
cables104527553c_ables
cacas95627983c_a_cas
calash11312433c_a_lash
calcar10312753c_alcar
calcars11312653c_alcars
calces104420053c_alces
calesa8412473c_alesa
calesas9411833c_alesas
calfs104919383c_a_lfs
califs114915893c_alifs
calks115421603c_a_lks
call66838673c_all__
callant94121223c_allant
callants104112143c_allants
called94126733c_alled
callee84327293c_allee
callees94117783c_allees
caller85125483c_aller
callers94221963c_allers
callet84536763c_allet
callets93821703c_allets
callose9313663c_allose
callous93516603c_allous
callow114714663c_allow
calms95222353c_a_lms
calos74431903c_a_los
calpac123211063c_alpac
calpacs133110343c_alpacs
calves115119283c_alves
calxes154113033c_alxes
camas96333523c_a_mas
canals84421663c_anals
canellas10310563canellas
cannas84518403c_annas
canolas9313993canolas
canulas9312853canulas
canvas113813333c_anvas
capias10318353c_apias
carles85435083c_arles
carls77037423c_arl_s
casas75327843c_a_sas
catalpas1246733catalpas
caulds95512383c_aulds
caules85927253c_aules
caulis85320083c_aulis
caulks125611863c_aulks
cauls75727773c_aul_s
cavalla1257883cavalla_
cedillas1145743cedillas
cedulas1058503cedulas
cella75420313c_ella_
cellae84915933c_ellae
cellar84514983c_ellar
cellars93713693c_ellars
cellos84517803c_ellos
cells75428063c_ell_s
chabuks1843733chabuks
chachkas22173733chachkas
chacma1537903chacma_
chadar1239353cha_dar
chadars1338293chadars
chadless1436403chadless
chadors1338753chadors
chads116122233cha__ds
chaeta11310683chaeta_
chaetae1238603chaetae
chaetal1238283chaetal
chafers154512743chafers
chafes145017913cha_fes
chaffs17459613cha_ffs
chaines124518733chaines
chains114819703cha_ins
chairs114916183cha_irs
chais107530313cha__is
chaises124317493chaises
chakra15437533chakra_
chalaza2145733chalaza
chalazae2244423chalazae
chalazal2243873chalazal
chalcid1537883chalcid
chalcids1635893chalcids
chaleh143711993cha_leh
chalet113825993cha_let
chalice14311043chalice
chalices15310813chalices
chalk144814603cha_l_k
chalked17449863chalked
chalky18468773cha_lky
challises14358783challises
challoth16316103challoth
chalone12312103chalone
chalones13312173chalones
chalot113020133cha_lot
chaloth15298603chaloth
chalupa1444473chalupa
chalutz2195093chalutz
chamisa14328853chamisa
chamisas15317813chamisas
chamois143512193chamois
champac1834953champac
champacs1934633champacs
champak2034493champak
champaks2134103champaks
champs154915683cha_mps
chams126028503cha__ms
chances145218093chances
changes134517583changes
changs125215373cha_ngs
chants115020393cha_nts
chaos105622863cha__os
chaoses124715123chaoses
chapeau1435523chapeau
chapeaus1544993chapeaus
chapels14429153chapels
chapes135421873cha_pes
chaplain1546193chaplain
chaplains1645743chaplains
chaplet14512253chaplet
chaplets1556883chaplets
chapman1637893chapman
chaps125326063cha__ps
chards125119733cha_rds
chares115631803cha_res
charges134615983charges
charka154011703charka_
charkhas20285023charkhas
charks155219703cha_rks
charlady1743403charlady
charley15118273charley
charleys1695633charleys
charlie123011923charlie
charlies133414233charlies
charms135218843cha_rms
charpai1436633charpai
charpais1536933charpais
charros124312143charros
charrs115219193cha_rrs
chars105936643cha__rs
charts115823093cha_rts
chasers123714923chasers
chases115128233cha_ses
chasmal14158213chasmal
chasms135513143cha_sms
chasses124017503chasses
chassis123910663chassis
chateau1236273chateau
chateaus1346013chateaus
chats105730093cha__ts
chaunts1267083chaunts
chawers154412053chawers
chaws135022463cha__ws
chays135319743cha__ys
chazan20269133cha_zan
chazans21268123chazans
chazzan20204853chazzan
chazzans21234503chazzans
chela103916803ch_ela_
chelae113614603ch_elae
chias104625523ch__ias
chiasmas15306593chiasmas
chicas135916473ch_icas
chicles143512503chicles
chields13507483chields
chiels115115933chiel_s
childes134211273childes
chiles115425303ch_iles
chiliad1337563chiliad
chiliads1445853chiliads
chiliasm15134513chiliasm
chiliast13117933chiliast
chilies124218303chilies
chilis115517873ch_ilis
chill105619873chill__
chilled133310933chilled
chiller124112183chiller
chillers133710923chillers
chillest13259593chillest
chilli114312773chill_i
chillies134113483chillies
chillum1435443chillum
chillums1544163chillums
chilly144113223chill_y
chimla1337593chimla_
chinas115119403ch_inas
chlamys1733783chlamys
chola104718033ch_ola_
choleras13289043choleras
cholers124215203cholers
cholos114716853ch_olos
chorals124614113chorals
choreas124414203choreas
chromas142512693chromas
chufas14397673ch_ufas
chukkas1532783chukkas
chuppas1644123chuppas
churls115411073churl_s
chyles144813283ch_yles
chylous15107273chylous
cicalas1139303cicalas
citolas939363citolas
coala77521123coa_la_
coalers94419353coalers
coalless1038193coalless
coals76129603coa_l_s
colas75436773c__olas
collar83816173c_ollar
collars93816573c_ollars
colzas174010513c_olzas
copulas113811563copulas
corollas1039213corollas
craals84113303craal_s
cradles103114133cradles
crapolas1247403crapolas
crawls114712083crawl_s
cullay113910173c_ullay
cullays12347703c_ullays
cullis84115993c_ullis
culls75425813c_ull_s
cupolas11277753cupolas
cutlas8313103c_utlas
czardas1934673czardas
dahlias1135723dahlias
dalles74222063_dalles
dhals95415443dha_l_s
dharmas1356513dharmas
dharnas1155373dharnas
echelles1346673echelles
fallal93612693_fallal
fallals103310193_fallals
falls85727653_fall_s
fellas95116963_fellas
galas65731643_ga_las
galeas74618513_galeas
galls64729323_gall_s
gallus74313203_gallus
ghylls1335143ghyll_s
hahas117118443_ha_has
hails85231643_hail_s
halal85623593_ha_lal
halala94715093_halala
halalah13429393_halalah
halalahs14367443_halalahs
halers94926913_halers
hales85449843_ha_les
halids104016133_halids
hall75741163_hall__
hallel93514093_hallel
hallels103310133_hallels
hallo85127553_hall_o
halloa94918123_halloa
halloes104021523_halloes
halloo95118973_halloo
halloos103716743_halloos
hallot95426783_hallot
hallow124818323_hallow
hallows134417393_hallows
hallux1637363_hallux
hallway1636173_hallway
hallways1745423_hallways
halma108219253_halma_
halms105225213_ha_lms
haloes94623863_haloes
halons95720713_halons
halos85230253_ha_los
halts85230103_ha_lts
halva115414433_halva_
halvah15499833_halvah
halvahs16417533_halvahs
halves124717093_halves
hamals114816823_hamals
hamzas20119013_hamzas
hansas94616043_hansas
haoles94919803_haoles
harls85634503_harl_s
haulms11558503_haulms
hauls86123733_haul_s
hawalas13348353_hawalas
hellos95321683_hellos
hells85032043_hell_s
hilloas104413553_hilloas
hillos94618893_hillos
hills85431353_hill_s
holla84918493_holla_
holloas103814943_holloas
hollos95320633_hollos
hulas84920883_h_ulas
hulloas103911913_hulloas
hullos94916293_hullos
hulls84923563_hull_s
hylas114815903_h_ylas
kalpas124112943_kalpas
khalifas1842513khalifas
khalifs1754073khalifs
koalas104011663koa_las
lallan63414173_lallan
lallans74113533_lallans
lalls55324133_lall_s
malls76233433_mall_s
mullas84215933_mullas
nalas55528363_na_las
nyalas936903nya_las
ollas54218283__ollas
paellas9411413paellas
palls74332563_pall_s
phalli1148263phall_i
phallic1447293phallic
phallism1545713phallism
phallist1338983phallist
phyllos1535583phyllos
psyllas1244883psyllas
salals65120083_salals
salpas85116923_salpas
salsas65316133_salsas
scalls84218203scall_s
scillas9310473scillas
shales94731253sha_les
shall85024053shall__
shallop12348453shallop
shallops13288323shallops
shallot103614133shallot
shallots11319503shallots
shallow13388873shallow
shallows14388863shallows
shaloms1288983shaloms
shamas113717943sha_mas
shammas14358723shammas
sharias102516003sharias
shauls94913113shaul_s
shawls125411973shawl_s
sheilas1059403sheilas
shellac1236693shellac
shellacs1345573shellacs
shells94319523shell_s
sheltas10279673sheltas
shills94519613shill_s
smalls84514123small_s
spalls84217343spall_s
stalls64019933stall_s
stellas72813043stellas
tablas83716163_tablas
talas55935893_ta_las
tallis63319963_tallis
talls55133433_tall_s
thalers106212263thalers
thalli958923thall_i
thallic1246553thallic
thallous1136523thallous
thills95515383thill_s
thralls10299043thrall_s
thulias1035743thulias
villas96117263_villas
walla85321033_walla_
wallah124011993_wallah
wallahs13409473_wallahs
walls85529383_wall_s
whalers13529703whalers
whales124716943wha_les

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.406440125.6
2DLD Change Limit1340274326.09621986.1
3Display Results4324320.1532823.5
 (SQL Overall)1786914326.65526850.6
 
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.