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

113 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
cheerless149529(None) 
cheekless1873881cheekless
checkless2044232checkless
cheerers13319542cheer_ers
cheeriest1438212cheeriest
cheeriness1545532cheeriness
cheerlead1593002cheerlead
cheerleads1692512cheerleads
cheerled14105712cheerle_d
cheerlessly1952082cheerlessly
coverless1436802coverless
heedless12278812_heedless
heelless11257652_heelless
heirless1146052_heirless
peerless1037512_peerless
sheerlegs1343292sheerlegs
sheerness1236272sheerness
sheetless1235822sheetless
wheelless1543772wheelless
angerless1045023angerless
beefless1335493_beefless
careless102813633care_less
carless95118493c__arless
cateress102311613cater_ess
centerless1245003centerless
chadless1436403ch_adless
charleys1695633ch_arleys
charmless1633583charmless
chartless1435703chartless
cheapness1643743cheapness
cheekiest1835703cheekiest
cheekiness1944043cheekiness
cheepers15329013chee_pers
cheered133713303cheer_e_d
cheerer123511763cheer_e_r
cheerfulness2053583cheerfulness
cheerier1348013cheerie_r
cheerios13317593cheer_ios
cheerly15417603cheerl__y
cheeros123711643cheer__os
cheers114518913cheer___s
cheeses123613103chee_se_s
cheesiest1436323cheesiest
cheesiness1544733cheesiness
cherries131812993cherrie_s
chevalets1743383chevalets
chevres15379793chevr_e_s
chevrets16255323chevr_ets
chewiness1744823chewiness
childless1543813childless
chinless1337493ch_inless
clearness1135633clearness
cleverness1543223cleverness
clueless1035883clue_less
codeless112010113code_less
coheiress1443353coheir_ess
colorless1145683colorless
coreless103013833core_less
cotterless1244033cotterless
coverlets1437053coverlets
crestless1146783crestless
crewless1335413c_rewless
cureless10319703cure_less
deedless10318253_deedless
dowerless1344013dowerless
earless74316073__earless
fearless1137873_fearless
feeless103511103_fee_less
feetless1137383_feetless
fiberless1444453fiberless
gearless937373_gearless
greedless1144893greedless
hairless1157413_hairless
headless12289863_headless
heartless1236393_heartless
heatless113011463_heatless
heelers103815633_hee_lers
heiress1036813_heir_ess
helmless1334273_helmless
helpless1335063_helpless
herbless1336663_herbless
hueless1058823_hue_less
keelless12236193_keelless
linerless936333linerless
needless9308333_needless
orderless1044313orderless
paperless1345833paperless
peeress939503_peer_ess
powerless1444293powerless
queerness1844213queerness
riderless1044903riderless
riverless1244943riverless
seedless9319513_seedless
seeress7311573_seer_ess
sewerless1244303sewerless
shearlegs1342493shearlegs
sheerest11310083sheer_est
shelterless1452043shelterless
shoeless1137803shoe_less
shoreless1236633shoreless
showerless1642543showerless
sleepless1144553sleepless
tearless848713_tearless
thewless1433923th_ewless
treeless839283tree_less
waterless1238013waterless
weedless12287963_weedless
wheatless1534003wheatless
wheedlers1643203wheedlers
wheedles1534653wheedle_s
wheelers14287743whee_lers
wheeples1634753wheeple_s
whelpless1742053whelpless

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411136.56322648.3
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.02925422.0
 
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.