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

132 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
emanating123900(None) 
emaciating1546822emaciating
emanation11910782emanation
emanations1289592emanations
emanative1447312emanative
emendating1444612emendating
emulating1239872emulating
geminating1447762geminating
managing1239092_managing
mandating1339772_mandating
abating10413973__abating
amanitin1048463amanitin_
amanitins1147133amanitins
anting75827023__an_ting
bemadaming1842183bemadaming
canaling112016413_canaling
canting104725903_can_ting
cementing1438763cemen_ting
chanting143413533chan_ting
comanaging1644323comanaging
deaminating1547973deaminating
decanting132510633decan_ting
demanding14237923deman_ding
demarcating1745203demarcating
demasting1338453dema_sting
dementing13311043demen_ting
detonating1248823detonating
dominating1449403dominating
donating10311803_donating
eanling81416673e_an_ling
easting84924303e_a_sting
eating75134403e___ating
educating1337933educating
elating83423083e__lating
elevating1338203elevating
eliminating1445543eliminating
elongating1244523elongating
emailing113010043ema_iling
emanant9411093emana__nt
emanate9312473emanat__e
emanated1139163emanat_ed
emanates10311333emanat_es
emanator1047293emanat_or
emanators1147033emanators
emancipating1952893emancipating
embanking1843813emban_king
embaying1635263em_baying
emblazing2344853emblazing
embracing1645443embracing
embruting1444283embruting
emending12298893emen_ding
emigrating1467503emigrating
emitting112410353em_itting
emoting10313563em__oting
empaling1338363em_paling
empaneling1573403empaneling
emplacing1645483emplacing
emplaning1446533emplaning
enacting11311363ena_cting
ensnaring1046383ensnaring
epilating12310973epilating
equating18310113e_quating
eradiating1248733eradiating
escalating1347093escalating
estating92614993e_stating
evacuating1645683evacuating
evaginating1644913evaginating
evaluating1456023evaluating
exacting1838523exa_cting
exalting1638033exa_lting
excavating2344113excavating
expiating1938543expiating
gemmating1576443gem_mating
germinating1546173germinating
gradating1237323gradating
granting103514523gran_ting
hanting114124483_han_ting
imitating1238763imitating
laminating1348733laminating
levanting1345523levan_ting
malting103219083_ma_lting
manacling1446283_manacling
manakin131810643_manakin_
manakins14209763_manakins
mangling122312623_mangling
manning103616383_man_ning
mantling112012613_mantling
manuring1139223_manuring
marinating13410273_marinating
marting103325013_ma_rting
masting104325823_ma_sting
mating94832913_m__ating
matting103620143_ma_tting
meaning103918703mean__ing
mediating13311203mediating
menacing1339783_menacing
minting103020813_min_ting
minuting1139723_minuting
moating104218153_m_oating
munting103718773_mun_ting
mutating112211753_mutating
nominating1349503nominating
oxalating1745803oxalating
ozonating1944323ozonating
panting104025423_pan_ting
phonating1537813phonating
placating1438513placating
planting113515383plan_ting
pronating12313763pronating
quanting1849233quan_ting
ranting84025413_ran_ting
recanting122414823recan_ting
remanding132211143reman_ding
remanning12229033reman_ning
remating112322423rem__ating
reminting122315103remin_ting
resinating11313733resinating
resonating11311263resonating
ruinating1039593ruinating
ruminating1348143ruminating
scanting113914763scan_ting
separating1348643separating
slanting94115093slan_ting
smarting113212453sma_rting
stagnating1254973stagnating
tenanting1036213tenan_ting
terminating1447353terminating
unabating1246753unabating
urinating10310653urinating
vacating14310363_vacating
venenating1446013venenating
wanting114220173_wan_ting

Search took 9 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 Filter1786911486410.436409841.7
2DLD Change Limit1486411327.93618730.0
3Display Results1321320.0632095.2
 (SQL Overall)1786911328.43521184.5
 
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.