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

294 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
fameless1325920(None) 
faceless13269171faceless
fadeless12258321fadeless
flameless1435351flameless
frameless1435531frameless
fumeless13236601fumeless
nameless10248371nameless
tameless10259901tameless
ageless8310342_ageless
aweless1038722_aweless
baseless1099562baseless
blameless1334732blameless
careless102813632careless
dateless9259962dateless
fangless1237662fangless
fatless103212202fa_tless
feeless103511102f_eeless
fireless112810592fireless
foamless13195842foam_less
fuseless11237232fuseless
gameness112810692gameness
gateless9279952gateless
homeless131110132homeless
laceless10239852laceless
lameness102612672lameness
limeless10249662limeless
maneless102812342maneless
mateless102711292mateless
paneless102611762paneless
sameness102712682sameness
shameless1435922shameless
tameness102411252tameness
tapeless10218642tapeless
timeless10239542timeless
wageless1237172wageless
wakeless1536472wakeless
waveless1437482waveless
abeles84719393_abele_s
aidless83612073_aidless
aimless93610813_aimless
airless73712043_airless
amblers115213563_amblers
ambles105121863_amble_s
ameers84015573_ame_ers
amoles84122193_amole_s
amplest11312333_amplest
amulets939923_amulets
aneles64626293_anele_s
armless9369943_armless
artless73712513_artless
ashless10318453_ashless
awless939263_a_wless
awnless1035923_awnless
backless162910633backless
badgeless1343203badgeless
barbless12318713barbless
bareness10912813bareness
barkless14318023barkless
barless94317003ba_rless
baseness10910943baseness
bathless13127383bathless
beamless12327003beam_less
bladeless1234303bladeless
boneless10310213boneless
brakeless1544993brakeless
cameleer1246033cameleer
cameleers1345093cameleers
camelias12510303camelias
camelids1356943camelids
camels105217083camel__s
camlets114314623cam_lets
capelets1268603capelets
capless114312763ca_pless
carless95118493ca_rless
cashless1336773cashless
cateress102311613cateress
causeless1135193causeless
ceaseless1135733ceaseless
clueless1035883clueless
codeless112010113codeless
coreless103013833coreless
crimeless1335063crimeless
cureless10319703cureless
dampness1336073dampness
earless74316073ea_rless
edgeless1034883edgeless
enamelers1144803enamelers
eyeless1058053_eyeless
fablers124812613fa_blers
fables114921673fa_ble_s
fadedness1445613fadedness
faeces114713123fa_ece_s
failles102914133faille_s
fairness1136563fairness
faithless1543903faithless
fakeers14446673fake_ers
fallers103917993fa_llers
falseness1236093falseness
fames105735923fam__e_s
families1339443families
familism1546343familism
familisms1645863familisms
famines123216263famine_s
famulus1235043famul_us
fanciless1444603fanciless
farles96025783fa_rle_s
farness102912203fa_rness
fartleks1533963fartleks
fastness11238763fastness
fatalness1245773fatalness
fatherless1644213fatherless
fatness103311293fa_tness
faultless1243163faultless
favelas1337023favel_as
favellas1446163favellas
fearless1137873fearless
feastless1235043feastless
feckless17225783feckless
feelers103814743f_eelers
feetless1137383feetless
females12310663female_s
fenceless1444163fenceless
fernless1136063fernless
fiberless1444453fiberless
filmless1344553filmless
fimbles143510663fimble_s
fineness11310643fineness
finless102810783f_inless
fishless1436413fishless
flagless1235403flagless
flapless1335343flapless
flawless1434503flawless
flyless1335003f_lyless
foaminess1437503foaminess
fogless1138193f_ogless
foodless12338383foodless
footless113710803footless
forceless1435723forceless
fordless12289003fordless
forelegs1236613forelegs
forkless15267433forkless
formless13248083formless
freeness11710443freeness
fretless1138063fretless
fuelers103912393f_uelers
fumblers15318713fumblers
fumbles143514413fumble_s
furless103210143f_urless
gainless9117403gainless
gamblers13369733gamblers
gambles124016203gamble_s
gamelans11115843gamelans
gametes10312253gamete_s
gaminess112911063gaminess
gapless10349993ga_pless
garbless11388253garbless
gasless8319013ga_sless
graceless12226893graceless
gradeless11236703gradeless
grateless10277583grateless
graveless13226693graveless
gumless10228273gum_less
hairless1157413hairless
haleness11312623haleness
haltless11308443haltless
hamlets123211403ham_lets
hammerless1742373hammerless
handless123512063handless
hapless123311333ha_pless
harmless1337403harmless
hatless103813443ha_tless
hideless12278713hideless
hiveless14227933hiveless
holeless1189363holeless
hopeless13118303hopeless
hueless1058823_hueless
humpless15226333humpless
hymnless1632803hymnless
iceless9219963_iceless
ireless72312243_ireless
isleless834853isleless
jagless1537103ja_gless
jawless1745653ja_wless
labelers10249413labelers
lamellas1098163lamellas
landless94011173landless
lateness82614073lateness
lawless1037033la_wless
lifeless11228143lifeless
limbless12246313limbless
lineless82711943lineless
loamless10235213loam_less
loveless1168573loveless
mailless10248583mailless
maleness10312313maleness
mameyes14376983mameye_s
manless93012933ma_nless
massless10277113massless
mastless102610023mastless
matless93014043ma_tless
melees83618083__melees
moveless1367753moveless
namelessly1542983namelessly
napless93110283na_pless
natheless1244963natheless
nathless11127023nathless
noseless839513noseless
noteless839403noteless
oarless73913373oa_rless
omelets938333_omelets
painless10108343painless
paleness10312983paleness
paperless1345833paperless
passless10247223passless
pastless102411203pastless
pathless13138043pathless
pileless1088623pileless
pipeless12107663pipeless
placeless1335613placeless
poleless1089873poleless
popeless1288473popeless
pumpless14236373pumpless
rainless8129703rainless
ramblers124010373ramblers
rambles113118313ramble_s
ramees84620893rame_e_s
rankless12268233rankless
rareness81112853rareness
ravelers113310863ravelers
rayless10239003ra_yless
rhymeless1741673rhymeless
rimless9369363rim_less
ruleless836633ruleless
rumpless12256543rumpless
safeness11239633safeness
sageness92111983sageness
sailless82410373sailless
saltless8259343saltless
samlets93813553sam_lets
samplers12299403samplers
samples112815453sample_s
sandless93212343sandless
saneness82313723saneness
sapless93313443sa_pless
sashless1136603sashless
scaleless1135513scaleless
seamless10238723seam_less
shadeless1335733shadeless
shapeless1435563shapeless
shoeless1137803shoeless
soleless8910033soleless
spaceless1335733spaceless
stampless1334543stampless
stateless937563stateless
stemless1036653stemless
sumless92611123sum_less
tableless1145033tableless
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
tamales93216153tamale_s
tankless12267823tankless
tasteless935673tasteless
taxless1436913ta_xless
tideless9269083tideless
tieless72512563_tieless
tireless82510263tireless
toeless72612393_toeless
tombless1236783tombless
toneless8610393toneless
traceless11228643traceless
tramless1037503tram_less
treeless839283treeless
tubeless1037023tubeless
tuneless837913tuneless
useless7188423_useless
valueless1242843valueless
valveless1543163valveless
viceless1337983viceless
voteless1137493voteless
waeness102512783wa_eness
wambles143714023wamble_s
wardless12249303wardless
warless104015103wa_rless
wartless11279923wartless
waterless1238013waterless
wattless11268723wattless
wavelets1436153wavelets
wayless13308243wa_yless
wifeless14277483wifeless
wineless112711173wineless
wireless11249633wireless
yokeless1535303yokeless
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.423422437.4
2DLD Change Limit1461622946.50022486.5
3Display Results2942940.1262333.3
 (SQL Overall)1786912947.04925349.8
 
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.