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 “enzyme” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
enzyme205434(None) 
enzym1964391enzym_
enzymes2164411enzymes
enzyms2063431enzyms
coenzyme2442992coenzyme
enzymic2343322enzymic
zyme1819114942__zyme
anime75423203an_ime
apoenzyme2551383apoenzyme
bename103316073ben_ame
benzene1836343benzene
benzine1839343benzine
benzole1837133benzole
benzyl2034163benzy_l
benzyls2133673benzyls
berhyme1743813berhyme
centime114513033centime
chyme156512503_chyme
coenzymes2542573coenzymes
cyme119420373__cyme
ectype1334283ectype
eczema1973073eczema
eme55837183e___me
emyde1136383e_myde
enable83318483enable
enamel81210113en_amel
enate54428153en_ate
encage93713503encage
encamp1235943encamp
encase83714363encase
encode9310443encode
encore8314773encore
encyst1136203encyst
endgame1145233endgame
endite73817593endite
endive103310473endive
endue64215353en_due
endure74014143endure
enema7612743en_ema
enemy1059993en_emy
enface112510353enface
enflame1236573enflame
enframe1247363enframe
engage82812103engage
engine71114863engine
enigma935643enigma
enisle63412093enisle
enlace82213233enlace
ennuye973753ennuye
ennuyee1084153ennuyee
enorm74415643enorm_
enrage72715073enrage
enrobe86610793enrobe
ensile62616473ensile
ensue54013833en_sue
ensure63416003ensure
entice81316863entice
entire61617703entire
entomb1037363entomb
entree61817883entree
enure53520223en_ure
envy10411253envy__
enwomb1344973enwomb
ethyne12407153ethyne
etyma1036583e_tyma
evzone1894683evzone
exhume1833803exhume
exoenzyme3051543exoenzyme
eye65539773e__y_e
eyne76322463e__yne
eyre75525253e__yre
genome94312193gen_ome
gnome84213953gn_ome
inbye10427063inby_e
income10712093income
inhume1196583inhume
intime81014273intime
isoenzyme2351623isoenzyme
isozyme21103293isozyme
name65637413_n_ame
neume74414403_neume
nome66038423_n_ome
penname11328553penname
proenzyme2552213proenzyme
rename82718813ren_ame
rhyme13479553_rhyme
snye77115493sn_y_e
thyme134612473_thyme
untame82513603untame
zymes1924712943__zymes

Search took 6 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.373479064.3
2DLD Change Limit112716905.18621734.7
3Display Results90900.0332727.3
 (SQL Overall)178691905.59231954.8
 
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.