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

293 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
chadless143640(None) 
capless114312762c_apless
carless95118492c_arless
chalehs15268802cha_lehs
chalets122813472cha_lets
chandlers15387672chandlers
chaplets1556882chaplets
charleys1695632charleys
charmless1633572charmless
chartless1435702chartless
childless1543812childless
chinless1337492chinless
clawless1334122clawless
coalless1038192coalless
coatless1039692coatless
cordless11299962cordless
cradlers11309182cradlers
cradles103114122cradle_s
handless123512062_handless
hapless123311332_hapless
hatless103813442_hatless
headless12289862headless
leadless9248792leadless
roadless937692roadless
shadeless1335732shadeless
thawless1434082thawless
toadless936302toadless
aidless83612073_aidless
awless939263__awless
badness1039573_badness
barless94317003_barless
beadles103414723beadle_s
beakless14297383beakless
beamless12327003beamless
beardless1234913beardless
beatless103311593beatless
bedless1039703_bedless
bladeless1234303bladeless
bondless1148813bondless
braless92910563bra_less
brandless1236123brandless
breadless1235943breadless
budless1038873_budless
cablers114416713c_ablers
cables104527553c_able_s
cablets114216343c_ablets
cades85440733c_ad_e_s
cadets96316503c_ad_ets
cadgers114711993c_adgers
cadges104716703c_adge_s
cadres94017923c_adre_s
calesa8412473c_a_lesa
calesas9411823c_a_lesas
callees94117773c_allees
callers94221963c_allers
callets93821703c_allets
camlets114314623c_amlets
candlers114214103candlers
candles104422343candle_s
caplets114914523c_aplets
careless102813633careless
caress85720263c_a_ress
carles85435083c_arle_s
cashless1336773cashless
caudles103912813caudle_s
caules85927253c_aule_s
ceaseless1135733ceaseless
chablis14368553chabl_is
chadars1338273chad_ars
chadors1338723chad_ors
chads116122233chad___s
chafers154512723cha_fers
chafes145017913cha_fe_s
chaffers19377993chaffers
chaines124518733chaine_s
chaises124317493chaise_s
chalahs15289883cha_lahs
chaleh143711993cha_le_h
chalet113825993cha_le_t
chalks155412143cha_l_ks
challahs16377563challahs
challas124414123cha_llas
challies133915633challies
challis124613463cha_llis
challises14358783challises
chambers173410613chambers
chamfers18409213chamfers
chamises153513313chamises
champers173311613champers
chancels15439083chancels
chancers154313483chancers
chances145218093chance_s
chandler14358373chandle_r
chandlery18384423chandlery
changeless1643873changeless
changers144313193changers
changes134517583change_s
channels13388493channels
chanters134016723chanters
chanteys16387493chanteys
chaoses124715113chaose_s
chapels14429153cha_pels
chapes135421873cha_pe_s
chaplet14512253chaple_t
chapters154012113chapters
charases131312753charases
chares115631803cha_re_s
chargers144011313chargers
charges134615983charge_s
chariest13315503chariest
chariness14310063chariness
charley15118273charle_y
charlies133414223charlies
charmers154211323charmers
charnels13328173charnels
charters134115563charters
chasers123714893cha_sers
chases115128233cha_se_s
chasses124017503chasse_s
chastens13429183chastens
chastest1349703chastest
chattels13286793chattels
chatters134213933chatters
chaufers16347283chaufers
chausses1345963chausses
chawers154412033cha_wers
chazzens21253943chazzens
cheapness1643743cheapness
checkless2044233checkless
cheders134512393ched_ers
cheekless1873883cheekless
cheerless1495293cheerless
chess105016923ch___ess
chicles143512503chicle_s
chicness1535593chicness
chiders135312943chid_ers
chides124620473chid_e_s
childes134211273childe_s
chiles115425303ch_ile_s
chillers133710913chillers
chillest13259593chillest
chillness1455373chillness
chimleys1883633chimleys
cholers124215193ch_olers
chudders15235553chudders
chyles144813283ch_yle_s
clades94920463clad_e_s
classless1143843classless
cloudless1243153cloudless
clueless1035883clueless
coalers94419333coa_lers
coatdress1243183coatdress
coddlers12359163coddlers
coddles114213593coddle_s
codeless112010113codeless
coldness1137953coldness
cookless14258633cookless
coreless103013833coreless
costless10310003costless
coxless1637743c_oxless
cradle93313163cradle__
cradled113410813cradle_d
cradler102910503cradle_r
crawlers13309003crawlers
crewless1335403crewless
cropless1237793cropless
cuddlers12388383cuddlers
cuddles114014093cuddle_s
cuffless1634283cuffless
curdlers11368493curdlers
curdles103814573curdle_s
cureless10319703cureless
deadness1039233deadness
deedless10318253deedless
earless74316063_earless
echoless1345603ech_oless
endless839833_endless
fadeless12258323_fadeless
fatless103212203_fatless
fearless1137863fearless
flagless1235403flagless
flapless1335343flapless
flawless1434503flawless
foamless13195843foamless
foodless12338383foodless
fordless12289003fordless
gapless10349993_gapless
gasless8319013_gasless
gearless937363gearless
gladness1036153gladness
glandless1134163glandless
goalless935723goalless
godless938403_godless
gradeless11236703gradeless
haddest122711993_haddest
hades96035113_had_e_s
hadjees18356383_hadjees
hadjes175210403_hadje_s
hailers104017263_hailers
hairless1157413_hairless
halers94926913_ha_lers
hales85449843_ha_le_s
halest94823273_ha_lest
hallels103310133_hallels
haltless11308443_haltless
hamlets123211403_hamlets
handlers124014143_handlers
handles114020653_handle_s
haoles94919803_haole_s
hardness122411083_hardness
harmless1337403_harmless
harness102413933_harness
haslets102510863_haslets
haulers104012443_haulers
heatless113011463heatless
heedless12278813heedless
hideless12278713_hideless
hipless12399923_hipless
hitless103211193_hitless
hoodless12289733hoodless
hueless1058823_hueless
jagless1537103_jagless
jawless1745653_jawless
kindless13289243kindless
ladlers84613563_ladlers
ladles74619543_ladle_s
landless94011173landless
lawless1037033_lawless
leafless11246573leafless
leakless12246983leakless
lidless8309273_lidless
loamless10235213loamless
lordless9277483lordless
madness10310073_madness
manless93012933_manless
matless93014043_matless
mealless10288363mealless
meatless103410863meatless
mindless11319443mindless
napless93110283_napless
needless9308333needless
oarless73913373_oarless
padles95221113_padle_s
peakless14236673peakless
planless1036813planless
playless1334863playless
rayless10239003_rayless
rindless92510193rindless
rodless8310073_rodless
sadness8310613_sadness
sandless93212343sandless
sapless93313443_sapless
scarless10189053scarless
seamless10238723seamless
seatless83213003seatless
seedless9319513seedless
shaders115915553shad_ers
shades105924533shad_e_s
shadiest121711273shadiest
shadiness1337463shadiness
shadowless1742093shadowless
shales94731253sha_le_s
shameless1435923shameless
shapeless1435563shapeless
shipless13277693shipless
shitless11249243shitless
shoeless1137803shoeless
snapless10287463snapless
soapless10278073soapless
sodaless936113sodaless
spanless10247363spanless
starless81610843starless
taxless1436903_taxless
tearless848703tearless
thalers106212263tha_lers
thankless1633203thankless
thewless1433923thewless
thowless1434613thowless
threadless1442473threadless
tramless1037503tramless
treadless1035993treadless
wardless12249303wardless
warless104015103_warless
wayless13308243_wayless
weedless12287963weedless
weldless12285813weldless
whalers13529703wha_lers
whales124716943wha_le_s
whatness1435093whatness
wheatless1534003wheatless
windless123310863windless
woodless12278453woodless
wordless12258843wordless

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.1701051123.5
2DLD Change Limit1461622938.61016975.8
3Display Results2932930.1262325.4
 (SQL Overall)1786912938.90620064.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.