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

179 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
emblems133504(None) 
emblem1237581emblem_
amblers115213562amblers
ambles105121862amble_s
embalms1335332embalms
embeds11377902emb_eds
embers104116182emb_ers
emblemed1544262emblemed
umbles103817492umble_s
ables75935543_able_s
ambeers11428923ambeers
ambers104519583amb_ers
amble95924643amble__
ambled115116373amble_d
ambler104916453amble_r
amoles84122193amole_s
amulets939923amulets
amylums1473613amylums
bibles104617643bible_s
bibless11439173bibless
blams95023853__blams
blebs96416153__blebs
bless75917813__bless
blets75324943__blets
bomblets1436023bomblets
bumblers143710733bumblers
bumbles134016843bumble_s
cablers114416713cablers
cables104527553cable_s
cablets114216343cablets
cobles104622883coble_s
eagles73819163eagle_s
eaglets84111663eaglets
earless74316073earless
ebbets10376833e_bbets
edibles1048003edible_s
ediles74016983edile_s
eggless935663eggless
egoless836983egoless
elemi7312503e__lemi
elemis8312383e__lemis
elms67322703e__l_ms
embalm1236653embalm_
embalmed1544263embalmed
embalmer1444063embalmer
embalmers1543773embalmers
embanks15295703embanks
embarks15337353embarks
embars103812883emb_ars
embays131408333emb_ays
embed105014303emb_e_d
ember95516803emb_e_r
emblaze2045773emblaze
emblazers2243703emblazers
emblazes2135673emblazes
emblements1647793emblements
embleming1644433embleming
emblemize2453063emblemize
emblemizes2552963emblemizes
emboldens1463563emboldens
embolies1239153embolies
embolism1446793embolism
embolisms1545633embolisms
embolus1135543embolus
embosks1594463embosks
embosoms1444393embosoms
emboss1087383emb_oss
embowels15224133embowels
embowers15236453embowers
embows1396823emb_ows
embrues1136473embrues
embryos1464093embryos
emcees1037813em_cees
emeers83314183em_eers
emes65434663em__e_s
emeses86114963emese_s
emeus76913333em__eus
emmers104013223em_mers
emmets10349153em_mets
emoters94712873emoters
emotes84620283emote_s
empalers12226743empalers
empales112411433empale_s
employs1455523employs
empress1138163empress
empyema1642643empyema
empyemas1742223empyemas
emulous937343emulous
emydes1236173emyde_s
enablers10196913enablers
enables92813123enable_s
endless839833endless
erbiums1135463erbiums
esteems935243esteems
exilers14419733exilers
exiles134816403exile_s
eyeless1058053eyeless
eyelets1057523eyelets
fablers124812613fablers
fables114921673fable_s
females12310663female_s
fimbles143510663fimble_s
fumblers15318713fumblers
fumbles143514413fumble_s
gables94222333gable_s
gamblers13369733gamblers
gambles124016203gamble_s
giblets103210423giblets
goblets103210183goblets
golems939323_golems
herbless1336663herbless
humblers15379803humblers
humbles143215803humble_s
imbalms1334553imbalms
imbeds11456743imb_eds
imbues1037983imbue_s
jobless16237563jobless
jumblers19358323jumblers
jumbles183013323jumble_s
limbless12246313limbless
males75049793_male_s
malms95021553_mal_ms
medleys13115333medleys
melees83618083_melees
members13258603memb_ers
mems85931503_m__ems
merles85322763merle_s
meseems1165603meseems
mewlers12288983mewlers
milers84625163_milers
miles74645073_mile_s
modems114610763_modems
moles74747923_mole_s
mules75034293_mule_s
muleys11409643_muleys
mumblers14328763mumblers
mumbles133014433mumble_s
nobles83319723noble_s
nombles113212343nomble_s
numbles113814273numble_s
ombers104214403omb_ers
ombres103911143ombre_s
omelets938333omelets
orbless937493orbless
pablums1345123pablums
pebbles1337573pebble_s
periblems1543483periblems
problems1434343problems
ramblers124010373ramblers
rambles113118313ramble_s
ribless93410343ribless
riblets93412553riblets
robles85321693roble_s
rubles83921703ruble_s
rumblers123610743rumblers
rumbles114018393rumble_s
sables85026693sable_s
smilers94113853smilers
smiles84522293smile_s
smileys12336323smileys
sublets92616703sublets
tables84524883table_s
tablets94714373tablets
temblors1244463temblors
temples112610893temple_s
templets12226143templets
tombless1236773tombless
tremblers1334483tremblers
trembles1237353tremble_s
tumblers123110623tumblers
tumbles113816023tumble_s
umbels104510593umb_els
umbers104215213umb_ers
verbless1336033verbless
wambles143714023wamble_s
webless1237003webless
wimbles143010853wimble_s
xylems1833203_xylems
ylems1039263__ylems

Search took 7 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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271796.70319995.1
3Display Results1791790.0632841.3
 (SQL Overall)1786911796.91925826.1
 
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.