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

114 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
enigma93564(None) 
enigmas1045171enigmas
anima74620072ani_ma
enema7612742en_ema
enigmata1143662enigmata
sigma84513832_sigma
stigma9226762stigma
agma77623263__agma
amiga85514813amig_a
anga56831353an_g_a
angina7413133angina
angioma1045753angioma
animal85016253ani_mal
animas84418723ani_mas
anime75423203ani_me
animi74016663ani_mi
benign938313benig_n
bima86723833_bi_ma
bregma1134963bregma
cinema1047653cinema
cnida878953cni_da
denim85518843deni_m_
denims95214323deni_ms
dogma96112463_dogma
eczema1973073eczema
edema8610553e_dema
eight94928053e_ight
emigre937053emigre
encamp1235943encamp
encina8310443encina
encomia1147983encomia
endgame1145233endgame
enemas8812003en_emas
enemy1059993en_emy
eng46726783en_g__
engild8107613engild
engine71114863engine
engird8126973engird
engirt71112613engirt
engram9310653en_gram
engs56121393en_g_s
enigmatic1446133enigmatic
enisle63412093enisle
enorm74415643enorm_
ensign737523ensig_n
ensigns836353ensigns
entera64216833entera
entia5318203en_tia
entomb1037363entomb
enwomb1344973enwomb
enzym1964393enzym_
enzyme2054343enzyme
enzyms2063433enzyms
eonism83213533eonism_
eonisms92811043eonisms
epigeal1046243epigeal
epigean1045503epigean
epigon937963epigon
epigram1247473epigram
epizoa1745013epizoa
erica7316543eri_ca
etyma1036583e_tyma
giga66720943_gig_a
glioma935953glioma
inia45024703ini__a
intima81910033intima
kerygma1741963kerygma
kinema1236023kinema
knight1438173knight
lima65734133_li_ma
linga66820823ling_a
lingam95112353lingam
lingua7509913lingua
magma104513573_magma
melisma1146473melisma
minima105512653minima
neigh94912383neig_h
neighs10387733neighs
nema65522523_n_ema
nigh85220663_nig_h
nighs95013613_nighs
night94327853_night
nim57142953_ni_m_
nims66226883_ni_ms
ninja1258093_ninja
nipa69421633_ni_pa
nizam16310253_nizam
noma67529463_n_oma
onium73115533onium_
pigmy13299433_pigmy
pima85428653_pi_ma
pneuma1035263pneuma
prima95019343pri_ma
regma84612333_regma
renig64518913renig__
renigs74314593renig_s
saiga64717933saig_a
senega738173seneg_a
seriema938403seriema
sigla64515203_sigla
sigmas94111363_sigmas
signa66114703_signa
sima64730783_si_ma
smegma1134113smegma
sterigma1144113sterigma
stigmal10245923stigmal
stigmas10206643stigmas
taiga64115663taig_a
tenia55324483teni__a
viga85622963_vig_a
vigia94813273_vigia
wingman1336383wingman
xenia124814773xeni__a
zeugma1842713zeugma

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.360496363.9
2DLD Change Limit1127161145.69019809.5
3Display Results1141140.0303800.0
 (SQL Overall)1786911146.08029390.0
 
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.