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

261 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
emblem123758(None) 
emblems1335041emblems
amble95924642amble_
ambled115116372ambled
ambler104916452ambler
ambles105121862ambles
embalm1236652embalm
embed105014302emb_ed
ember95516802emb_er
emblemed1544272emblemed
umbles103817492umbles
able66340533_able_
abled86926833_abled
abler75624313_abler
ables75935543_ables
ambeer104511603ambeer
amber94523213amb_er
amblers115213563amblers
amole75724593amole_
amoles84122193amoles
ample94720303ample_
ampler104313303ampler
amulet8419573amulet
amylum1344693amylum
bible95119423bible_
bibles104617643bibles
blam86131703__blam
bleb85425223__bleb
bled75729313__bled
blet66247673__blet
blew94722433__blew
bomblet13412263bomblet
bumble124216893bumble_
bumbled144113043bumbled
bumbler134013233bumbler
bumbles134016843bumbles
cable95329913cable_
cabled114819873cabled
cabler104519173cabler
cables104527553cables
cablet104429463cablet
coble94823173coble_
cobles104622883cobles
eagle64219483eagle_
eagled82914043eagled
eagles73819163eagles
eaglet73722583eaglet
ebbed104111003e_bbed
ebbet93517293e_bbet
edible969353edible_
edibles1048003edibles
edile64819493edile_
ediles74016983ediles
elemi7312503e__lemi
elm57531743e__l_m
emailed10359213emailed
embalmed1544263embalmed
embalmer1444063embalmer
embalms1335333embalms
embank14346553embank
embar94011603emb_ar
embark14458523embark
embars103812883embars
embay123410603emb_ay
embayed1535443embayed
embays131408333embays
embeds11377903embeds
embers104116183embers
emblaze2045773emblaze
emblazed2244743emblazed
emblazer2144563emblazer
emblazes2135673emblazes
embleming1644433embleming
emblemize2453063emblemize
embody1435033embody
embolden1354393embolden
emboli1037483emboli
embolic1347423embolic
embolies1239153embolies
embolism1446793embolism
embolus1135543embolus
emboly1336723emboly
embosk1464863embosk
embosom1344913embosom
emboss1087383emboss
embow1297563emb_ow
embowed15236903embowed
embowel14235343embowel
embower14267403embower
embows1396823embows
embrue1036533embrue
embrued1235293embrued
embrues1136473embrues
embryo1363963embryo
emcee9315943em_cee
emceed1136283emceed
emcees1037813emcees
eme55837183em__e_
emeer74815363em_eer
emes65434663em__es
emeses86114963emeses
emeu66723433em__eu
emmer94314463em_mer
emmet94221383em_met
emote75421193emote_
emoted94614923emoted
emoter85415193emoter
emotes84620283emotes
empale102611263empale_
empaled12288953empaled
empaler11288353empaler
empales112411433empales
employ1346493employ
empyema1642643empyema
emyde1136383emyde_
emydes1236173emydes
enable83318483enable_
enabled102510633enabled
enabler9299363enabler
enables92813123enables
erbium1038083erbium
esteem838813esteem
eviler94811893eviler
exile126117653exile_
exiled144712463exiled
exiler134712183exiler
exiles134816403exiles
eyelet9514533eyelet
fable105824753fable_
fabled124216383fabled
fabler116115813fabler
fables114921673fables
feeble1138253feeble_
feebler1235823feebler
female11310553female_
females12310663females
fimble133611753fimble_
fimbles143510663fimbles
fumble133214263fumble_
fumbled153710493fumbled
fumbler143610813fumbler
fumbles143514413fumbles
gable85325523gable_
gabled105518453gabled
gables94222333gables
gamble115417183gamble_
gambled134112163gambled
gambler123612683gambler
gambles124016203gambles
giblet93418893giblet
goblet93219483goblet
golem8416113_golem
humble133615053humble_
humbled153711813humbled
humbler143411943humbler
humbles143215803humbles
imbalm1246323imbalm
imbed105013653imb_ed
imbue939483imbue_
imbued1136173imbued
imbues1037983imbues
impled113812513impled
jumble174012653jumble_
jumbled19379963jumbled
jumbler183910273jumbler
jumbles183013323jumbles
male66052303_male_
males75049793_males
malm85129983_mal_m
medley1298343medley
melee73729103_melee
melled95023023melled
mem77943473_m__em
member12258853memb_er
merle75824373merle_
merles85322763merles
mewled123710053mewled
mewler113510233mewler
mile66352573_mile_
miler75733063_miler
miles74645073_miles
mobled113213183mobled
modem103717143_modem
mole66251833_mole_
moles74747923_moles
mule65236973_mule_
muled85824433_muled
mules75034293_mules
muley104819283_muley
mumble123614343mumble_
mumbled143010763mumbled
mumbler133510913mumbler
mumbles133014433mumbles
nimble103412943nimble_
nimbler11358063nimbler
noble74420993noble_
nobler83713453nobler
nobles83319723nobles
nombles113212343nombles
numbles113814273numbles
omber95316443omb_er
ombre94111803ombre_
ombres103911143ombres
omelet8317073omelet
pablum1237503pablum
pebble1238003pebble_
pebbled1445403pebbled
pebbles1337573pebbles
periblem1445513periblem
problem1335983problem
ramble104519973ramble_
rambled123913523rambled
rambler113313263rambler
rambles113118313rambles
riblet84222443riblet
roble75223023roble_
robles85321693robles
ruble74521253ruble_
rubles83921703rubles
rumble103718813rumble_
rumbled124514593rumbled
rumbler113514113rumbler
rumbles114018393rumbles
sable74732163sable_
sables85026693sables
semple103212753semple_
smile74823923smile_
smiled93716433smiled
smiler83916683smiler
smiles84522293smiles
smiley114012303smiley
sublet82827243sublet
table75429603table_
tabled94020043tabled
tables84524893tables
tablet84227643tablet
temblor1144093temblor
temple102811333temple_
templed12278563templed
temples112610893temples
templet112712003templet
tremble1138003tremble_
trembled1335253trembled
trembler1235363trembler
trembles1237353trembles
tumble103215643tumble_
tumbled123412243tumbled
tumbler113412823tumbler
tumbles113816023tumbles
umbel93612843umb_el
umbeled12208193umbeled
umbels104510593umbels
umber94617593umb_er
wamble134415753wamble_
wambled153610753wambled
wambles143714023wambles
wimble133211923wimble_
wimbled15298153wimbled
wimbles143010853wimbles
xylem1736123_xylem
ylem9217893__ylem

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162615.61020092.0
3Display Results2612610.1102372.7
 (SQL Overall)1786912616.11029245.7
 
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.