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

244 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
chaplets155688(None) 
caplets114914521c_aplets
chalets122813471cha_lets
chaplet14512251chaplet_
cablets114216342c_ablets
callets93821702c_allets
camlets114314622c_amlets
capelets1268602c_apelets
capless114312762c_apless
caplet104226812c_aplet_
chadless1436402chadless
chalehs15268802cha_lehs
chalet113825992cha_let_
chapels14429152chap_els
chapes135421872chap_e_s
chapleted1743972chapleted
chapters154012132chapters
charleys1695632charleys
couplets12389872couplets
hamlets123211402_hamlets
hapless123311332_hapless
haslets102510862_haslets
aglets73915683__aglets
applets115710063_applets
ballets93719513_ballets
cablers114416713c_ablers
cables104527553c_able_s
cablet104429463c_ablet_
cachets145014263c_achets
cadets96316513c_a_dets
callees94117783c_allees
callers94221963c_allers
callet84536763c_allet_
camlet104426583c_amlet_
capelet11517073c_apelet_
capers105428143c_ap_ers
capes95441923c_ap_e_s
caplins113515993c_aplins
capotes11314643c_apotes
cappers134419403c_appers
carets85330773c_a_rets
carles85435083c_arle_s
carless95118493c_arless
carnets93918403c_arnets
carpets113915333c_arpets
caskets133910173c_askets
caules85927253c_aule_s
chablis14368563chabl_is
chaeta11310683cha__eta
chafers154512743cha_fers
chafes145017913cha_fe_s
chaffers19378003chaffers
chaines124518733chaine_s
chaises124317493chaise_s
chalahs15289883cha_lahs
chaleh143711993cha_le_h
chalks155412143cha_l_ks
challahs16377563challahs
challas124414123cha_llas
challies133915643challies
challis124613463cha_llis
challot123613263challot_
challoth16316103challoth
chalot113020133cha_lot_
chaloth15298603cha_loth
chalutz2195093cha_lutz
chambers173410623chambers
chamfers18409223chamfers
champers173311623champers
champleve2141853champleve
champleves2242283champleves
chancels15439093chancels
chancers154313493chancers
chances145218093chance_s
chandlers15387673chandlers
changers144313203changers
changes134517583change_s
channels13388503channels
chanters134016743chanters
chanteys16387493chanteys
chants115020393cha__nts
chaoses124715123chaose_s
chapati14118023chap_ati
chapatis15127943chapatis
chapatti15113873chapatti
chapattis1683613chapattis
chape125221143chap_e__
chapeau1435523chap_eau
chapeaus1544993chapeaus
chapel134911373chap_e_l
chapiter1536603chapiter
chapiters1635203chapiters
chaplain1546193chaplain
chaplains1645743chaplains
chapmen1637283chapme_n
chappati17124013chappati
chappatis18114013chappatis
chapped172711443chappe_d
chappies172610103chappies
chaps125326063chap___s
chapt125827643chap__t_
chapter144213853chapte_r
chaqueta2242753chaqueta
chaquetas2342193chaquetas
chares115631803cha_re_s
chargers144011323chargers
charges134615983charge_s
chariest13315513chariest
chariots1339393chariots
charley15118273charle_y
charlies133414233charlies
charmers154211333charmers
charmless1633583charmless
charnels13328173charnels
charters134115593charters
chartless1435703chartless
charts115823093cha__rts
chasers123714923cha_sers
chases115128233cha_se_s
chasses124017503chasse_s
chastens13429183chastens
chastest1349703chastest
chats105730093cha___ts
chattels13286793chattels
chatters134213953chatters
chaufers16347303chaufers
chaunts1267083cha_unts
chawers154412053cha_wers
chayotes1636503chayotes
chazzens21253943chazzens
cheapens15305943cheap_ens
cheapest1536073cheap_est
cheapies1539033cheapie_s
cheapness1643743cheapness
chevalets1743383chevalets
chevrets16255323chevrets
chicles143512503chicle_s
chiles115425303ch_ile_s
chillers133710923chillers
chillest13259593chillest
chimleys1883633chimleys
chinless1337493chinless
chippers173510883chippers
cholents1337623ch_olents
cholers124215203ch_olers
choppers174110463choppers
chyles144813283ch_yle_s
circlets1235663circlets
clappers143310833clappers
clarets94111103cla_rets
clawless1334123clawless
coalers94419353coa_lers
coalless1038193coalless
coalpits1245403coalpits
coapts104614013coap__ts
coatless1039693coatless
collets93517903c_ollets
complects1766413complects
complete143412053complete
completes153212923completes
complots1438163complots
coplots11511593c_oplots
corslets1038273corslets
couplers123311323couplers
couples115317053couple_s
couplet114717943couplet_
cradlers11309203cradlers
cradles103114133cradle_s
crapes104727693crap_e_s
crappers144011023crappers
crawlers13309013crawlers
cropless1237793cropless
culets85518513c__ulets
cullets94015613c_ullets
cutlets94113653c_utlets
droplets1136063droplets
eaglets84111663_eaglets
epaulets1043733epaulets
flapless1335343flapless
flatlets1147373flatlets
gallets83517403_gallets
gapless10349993_gapless
haets86525123_ha__ets
haffets1636053_haffets
hailers104017263_hailers
halers94926923_ha_lers
hales85449843_ha_le_s
halest94823273_ha_lest
hallels103310133_hallels
halts85230103_ha_l_ts
hamlet113722793_hamlet_
haoles94919803_haole_s
haplite12310703_haplite
haplites1339993_haplites
haplonts1345773_haplonts
happens14359173_happens
haptens124511343_haptens
harlots103413293_harlots
harslets1137833_harslets
haslet93222713_haslet_
hatless103813443_hatless
haulers104012443_haulers
hipless12399923_hipless
howlets13329223_howlets
lappets11329133_lappets
leaflets11244813leaflets
mallets93318493_mallets
maples104819423_maple_s
napless93110283_napless
octuplets1342223octuplets
palets85122313_pa_lets
pallets93919303_pallets
playlets1334903playlets
rhaphes1534703rhaphe_s
ripplets12316733ripplets
sallets73719653_sallets
samlets93813553_samlets
sapless93313443_sapless
scarlets10178573scarlets
schappes1736043schappe_s
shales94731253sha_le_s
shallots11319503shallots
shapeless1435573shapeless
shapers124016893shap_ers
shapes115124953shap_e_s
shipless13277693shipless
snapless10287463snapless
soapless10278073soapless
staplers103111203staplers
staples93617213staple_s
starlets81610083starlets
tablets94714383_tablets
tappets113610013_tappets
templets12226143templets
thalers106212263tha_lers
thawless1434083thawless
triplets103510263triplets
valets93715623_va_lets
varlets10411573_varlets
wallets103914833_wallets
whalers13529713wha_lers
whales124716943wha_le_s
whappers18276743whappers
whippets18255253whippets

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.440406115.9
2DLD Change Limit1461622446.89021213.6
3Display Results2442440.1102218.2
 (SQL Overall)1786912447.44024017.6
 
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.