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

134 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
enzym196439(None) 
enzyme2054341enzyme
enzyms2063431enzyms
benzyl2034162benzyl
enemy1059992enemy
enorm74415632enorm
envy10411252envy_
enzymes2164412enzymes
enzymic2343322enzymic
anomy105113393anomy
anonym1136383anonym
any68440483an_y_
bendy115017253bendy_
bendys12518383bendys
benny105217363benny_
benzal1739643benzal
benzin1738933benzin
benzol1756993benzol
benzoyl2143363benzoyl
benzyls2133673benzyls
centum104012363centum
coenzyme2442993coenzyme
cozy185823803cozy_
denim85518843den_im
deny86027123den_y_
dozy175920323dozy_
easy76224493easy_
eczema1973073eczema
eddy93912093eddy_
edgy94713523edgy_
eely77725213eely_
eery76129623eery_
eggy96611853eggy_
elm57531743e__lm
elmy95616793elmy_
em49445153e___m
emmy116013243emmy_
emmys12446023emmys
emyd1047073e_myd
en28052393en___
enact73525363enact
enate54428143enate
encamp1235943encamp
encyst1136203encyst
end46834353en__d
ended74421263ended
ender64325863ender
endow94510983endow
ends56528523en_ds
endue64215353endue
enema7612743enema
eng46726783en__g
engram9310653engram
engs56121393en_gs
enigma935643enigma
enjoy1545963enjoy
enjoys1644603enjoys
ennui537523ennui
ennuye973753ennuye
enoki9268873enoki
enol45823823en_ol
enols54718403enols
enow77819873en_ow
enows85115493enows
enrol51014283enrol
ens37245923en__s
ensky1235093ensky
ensue54013833ensue
enter54726383enter
entia5318203entia
entomb1037363entomb
entry82414263entry
enuf7323843en_uf
enure53520223enure
envoi878023envoi
envoy1156713envoy
envoys1255133envoys
enwomb1344973enwomb
eonism83213533eonism
eponym1345793eponym
espy969373espy_
ethyl1136513ethyl
etyma1036583e_tyma
exam132514623e_xam
exonym1844583exonym
eye65539773e__ye
eyry106315883eyry_
fenny115115133fenny_
fezzy199811453fezzy_
fozy197017163fozy_
frenzy2135883frenzy_
genom83716843gen_om
gym95719063__gym
hazy1918119193hazy_
henry114014473henry_
henrys12366103henrys
inarm7314423inarm
inby95315663inby_
inbye10427063inbye
inky115321583inky_
inly75622213inly_
jenny153811623jenny_
lazy166423073lazy_
lezzy16608083lezzy_
mazy186419693mazy_
mentum104511713mentum
nam55953393_n_am
nay66952773_nay_
nays75931593_nays
neem67328083_neem
neum66723083_neum
nim57142953_n_im
nizam16310253nizam
nom510450643_n_om
norm66429813_norm
onium73115533onium
only75319723only_
onyx1478363on_yx
oozy167018133oozy_
penny105119453penny_
pentyl1138813pentyl
senryu934493senryu
sensum849353sensum
sizy164816393sizy_
snye77115493sn_ye
tenty86121603tenty_
unarm7314453unarm
undy85015163undy_
unjam1448723unjam
unzip16207623unzip
venom103914863ven_om
wenny114412463wenny_
zuzim1534863zuzim
zyme1819114943__zyme

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 Filter178691836670.486367677.0
2DLD Change Limit836671346.14013626.5
3Display Results1341340.0334060.6
 (SQL Overall)1786911346.65926834.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.