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

152 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
embower1426741(None) 
embowed15236911embowed
embowel14235351embowel
embowers15236451embowers
empower14217031empower
imbower14235661imbower
bower107328182__bower
elbowed13235482elbowed
ember95516802emb__er
embodier1345082embodier
emborder1345082emborder
embosser1244282embosser
embow1297562embow__
embowels15224132embowels
embowered1743412embowered
embows1396822embow_s
emoter85415192em_oter
empowers15276842empowers
endower1138482endower
imbowers15295092imbowers
impower14247122impower
mower104523452_m_ower
ambeer104511603amb_eer
amber94523213amb__er
ambler104916453amb_ler
ambones11312683ambones
avower1236823_avower
beflower16166283beflower
bellower13159073bellower
bestower13126213bestower
blower115316573_blower
boner75133083__boner
borer75131273__borer
bowed114533423__bowed
bowel105621203__bowel
bowers115523703__bowers
bowery146012113__bowery
bowler114217313__bowler
bowyer14368923__bowyer
boxer145016523__boxer
cower104531773__cower
crower114117563_crower
deboner103110483deboner
deflower15126083deflower
dower95027703__dower
echoer114011103echo_er
elbow10117713elbow__
elbows1196723elbow_s
eloper85414153e_loper
embalmer1444063embalmer
embar94011603emb__ar
embayed1535443embayed
embed105014303emb__ed
embers104116183emb__ers
embitter12245623embitter
emblazer2144563emblazer
emblem1237583emb_lem
embodied1445303embodied
embodiers1443753embodiers
embodies1337003embodies
embody1435033embo_dy
embolden1354393embolden
emboli1037483embo_li
embolic1347423embolic
embolies1239153embolies
embolus1135543embolus
emboly1336723embo_ly
emborders1444573emborders
embosk1464863embo_sk
embosked1743703embosked
embosks1594463embosks
embosom1344913embosom
emboss1087383embo_ss
embossed1344703embossed
embossers1343413embossers
embosses1235963embosses
emboweled1743223emboweled
embowering1863413embowering
embowing1636243embowing
embracer1496463embracer
embroider1444233embroider
embroiler1344093embroiler
embrown1454803embrow_n
embrowned1743303embrowned
embrowns1544053embrowns
embrue1036533embrue_
embrued1235293embrued
embrues1136473embrues
emeer74815363em__eer
emender10649843emender
emitter93211083emitter
emmer94314463em__mer
emote75421193em_ote_
emoted94614923em_oted
emoters94712873em_oters
emotes84620283em_otes
empaler11288353empaler
employer1564713employer
empowered1743053empowered
emptier1187603emptier
encoder1038633encoder
endowed1248173endowed
endowers1238233endowers
enjoyer1744383enjoyer
enrober9218623enrober
evoker13467913e_voker
ewer77523983e___wer
exposer1637413exposer
flower124815503_flower
glower105114933_glower
grower104614933_grower
imbiber1333593imbiber
imbowered1742553imbowered
imposer113310103imposer
impowers15296823impowers
knower1337083_knower
kotower1434383kotower
laborer9249513laborer
lower85830413__lower
mellower13167413mellower
member12258853memb__er
meowed12148003_meowed
mobber123613463_mobber
mooner85317833_mooner
mooter83921093_mooter
moper94925923_m_oper
mover104220863_m_over
mowed113629013_m_owed
mowers113219403_m_owers
omber95316443omb__er
plower114315063_plower
power105325953__power
prower114218123_prower
reflower14126853reflower
remoter94815973rem_oter
remover124612273rem_over
repower12329883repower
reshower14107063reshower
rower85430493__rower
shower124315113_shower
slower94016153_slower
smoker124311693sm_oker
sower85229313__sower
taborer9269293taborer
thrower1387003thrower
tower85729203__tower
umber94617593umb__er
umbones1138013umbones
unbowed132610243unbowed
vower115220793__vower
widower1435343widower
yellower14186223yellower

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.393454684.5
2DLD Change Limit1340271525.85622887.1
3Display Results1521520.0463304.3
 (SQL Overall)1786911526.29528386.2
 
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.