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

266 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
wakeless153647(None) 
wageless1237171wageless
waveless1437481waveless
ageless8310342_ageless
aweless1038722_aweless
baseless1099562baseless
brakeless1544992brakeless
careless102813632careless
dateless9259962dateless
faceless13269172faceless
fadeless12258322fadeless
fameless13259202fameless
gateless9279952gateless
laceless10239852laceless
maneless102812342maneless
mateless102711292mateless
nameless10248372nameless
paneless102611762paneless
tameless10259902tameless
tapeless10218642tapeless
waeness102512782wa_eness
wakeners1535842wakeners
wardless12249302wardless
warless104015102wa_rless
wartless11279922wartless
waterless1238012waterless
wattless11268722wattless
wavelets1436152wavelets
wayless13308242wa_yless
wifeless14277482wifeless
wineless112711172wineless
wireless11249632wireless
yokeless1535302yokeless
abeles84719393_abele_s
aidless83612073_aidless
aimless93610813_aimless
airless73712043_airless
akees96119243_ake_e_s
akelas10311193_akel_as
akenes104817343_akene_s
aneles64626293_anele_s
armless9369943_armless
artless73712513_artless
ashless10318453_ashless
awakeners1643093awakeners
awareness1236343awareness
awless939263_a_wless
awnless1035923_awnless
backless162910633backless
badgeless1343203badgeless
barbless12318713barbless
bareness10912813bareness
barkless14318023barkless
barless94317003ba_rless
baseness10910943baseness
bathless13127383bathless
beakless14297383beak_less
bladeless1234303bladeless
blameless1334733blameless
boneless10310213boneless
cakiness1449553cakiness
capelets1268603capelets
capless114312763ca_pless
carless95118493ca_rless
cashless1336773cashless
cateress102311613cateress
causeless1135193causeless
ceaseless1135733ceaseless
clueless1035883clueless
codeless112010113codeless
coreless103013833coreless
cureless10319703cureless
earless74316073ea_rless
edgeless1034883edgeless
eyeless1058053_eyeless
fakeers14446673fake_ers
fangless1237663fangless
fatless103212203fa_tless
feeless103511103_feeless
fireless112810593fireless
flameless1435353flameless
frameless1435533frameless
fumeless13236603fumeless
fuseless11237233fuseless
gainless9117403gainless
gameness112810693gameness
gapless10349993ga_pless
garbless11388253garbless
gasless8319013ga_sless
graceless12226883graceless
gradeless11236703gradeless
grateless10277573grateless
graveless13226693graveless
hairless1157413hairless
hakeems16394803hake_ems
haleness11312623haleness
haltless11308443haltless
handless123512063handless
hapless123311333ha_pless
harmless1337403harmless
hatless103813443ha_tless
hideless12278713hideless
hiveless14227933hiveless
holeless1189363holeless
homeless131110133homeless
hopeless13118303hopeless
hueless1058823_hueless
iceless9219963_iceless
inkless11348713ink_less
ireless72312243_ireless
isleless834853isleless
jacketless2341763jacketless
jagless1537103ja_gless
jawless1745653ja_wless
keleps12478813__keleps
keyless1436163__keyless
labelers10249413labelers
lakebeds1542583lakebeds
lameness102612673lameness
landless94011173landless
lateness82614073lateness
lawless1037033la_wless
leakless12246983leak_less
lifeless11228143lifeless
likeness12229863likeness
limeless10249663limeless
lineless82711943lineless
loveless1168573loveless
mailless10248583mailless
maleness10312313maleness
manless93012933ma_nless
massless10277113massless
mastless102610023mastless
matless93014043ma_tless
moveless1367753moveless
nakedest1345473nakedest
nakedness1445043nakedness
napless93110283na_pless
natheless1244963natheless
nathless11127023nathless
noseless839513noseless
noteless839403noteless
oarless73913373oa_rless
painless10108343painless
paleness10312983paleness
paperless1345833paperless
passless10247223passless
pastless102411203pastless
pathless13138043pathless
peakless14236683peak_less
pileless1088623pileless
pipeless12107663pipeless
placeless1335613placeless
poleless1089873poleless
popeless1288473popeless
rainless8129703rainless
rakees104516973rake_e_s
rankless12268233rankless
rareness81112853rareness
ravelers113310863ravelers
rayless10239003ra_yless
ruleless836633ruleless
safeness11239633safeness
sageness92111983sageness
sailless82410373sailless
saltless8259343saltless
sameness102712683sameness
sandless93212343sandless
saneness82313723saneness
sapless93313443sa_pless
sashless1136603sashless
scaleless1135513scaleless
shadeless1335733shadeless
shameless1435923shameless
shapeless1435563shapeless
shoeless1137803shoeless
smokeless1543553smokeless
soleless8910033soleless
spaceless1335733spaceless
stateless937563stateless
tableless1145023tableless
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
tameness102411253tameness
tankless12267823tankless
tasteless935673tasteless
taxless1436903ta_xless
tideless9269083tideless
tieless72512563_tieless
timeless10239543timeless
tireless82510263tireless
toeless72612393_toeless
toneless8610393toneless
traceless11228643traceless
treeless839283treeless
tubeless1037023tubeless
tuneless837913tuneless
useless7188423_useless
vakeels14113733vake_els
valueless1242843valueless
valveless1543163valveless
viceless1337983viceless
voteless1137493voteless
wabblers15398993wabblers
wabbles144013993wabble_s
wackiness1836523wackiness
waddlers13298333waddlers
waddles124314843waddle_s
wafflers17306323wafflers
waffles16329983waffle_s
wagerers12247613wagerers
waggles123812003waggle_s
wailers103916803wa_ilers
waistless1235093waistless
waitress1135223waitress
wakames1635283wakame_s
wakefulness2154583wakefulness
wakened1546873wakene_d
wakener1446913wakene_r
wakens135012043wak__ens
wakers134822493wak__ers
wakes126633653wak__e_s
walers94824463wa__lers
wales86142833wa__le_s
wallets103914833wa_llets
wambles143714023wamble_s
wanglers123310033wanglers
wangles113416933wangle_s
wanness102610683wa_nness
warblers13319103warblers
warbles123215563warble_s
wardress12256163wardress
wariness11313213wariness
warmness1337063warmness
warslers11328073warslers
warsles103413643warsle_s
waterers112312783waterers
wattles103814073wattle_s
wavelessly1942893wavelessly
wavelet13310943wavele_t
waverers14318613waverers
waviness1437723waviness
waxiness1836723waxiness
weakeners1644163weakeners
weakness1535353weak_ness
weariless1234763weariless
webless1237003w_ebless
weedless12287963weedless
weldless12285813weldless
wheelers14287733wheelers
wheelless1543763wheelless
wickless1736083wickless
wideness12259473wideness
wigless11359673w_igless
windless123310863windless
wingless122910023wingless
winless103212283w_inless
wiseness112010753wiseness
wishless1435993wishless
witless103310983w_itless
woeness1020211543w_oeness
woodless12278453woodless
wordless12258843wordless
workless15276803workless
zoneless1737823zoneless

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.1701051123.5
2DLD Change Limit1461622667.59319249.6
3Display Results2662660.1102418.2
 (SQL Overall)1786912667.87322696.7
 
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.