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

97 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
enjoyer174438(None) 
enjoyed1834521enjoyed
enjoyers1843881enjoyers
annoyer1095602annoyer
encoder1038632encoder
endower1138482endower
enjoiner15225652enjoiner
enjoy1545962enjoy__
enjoys1644602enjoy_s
enrober9218622enrober
annoyed1185873annoyed
annoyers1185033annoyers
cajoler16398393cajoler
caloyer1238143caloyer
coyer105222843__coyer
decoyer13348683decoyer
deployer1445633deployer
echoer114011103echo_er
eloper85414153e_loper
embower14267403embower
emoter85415193e_moter
employer1564713employer
empower14217033empower
enabler9299363enabler
encloser10107183encloser
encode9310443encode_
encoded1139033encoded
encoders1137513encoders
encodes10310643encodes
encore8314773encore_
encored10412103encored
encores9315213encores
ender64325863en__der
endoderm12115253endoderm
endogen938613endogen
endorser966733endorser
endowed1248173endowed
endowers1238233endowers
endurer83210363endurer
enfever1344643enfever
enfolder1286153enfolder
enforcer13246503enforcer
engager9278603engager
enjoin1357833enjo_in
enjoinder1742723enjoinder
enjoined16215723enjoined
enjoiners16234623enjoiners
enjoins1457333enjoins
enjoying1935003enjoying
enjoyment2145033enjoyment
ennobler1043543ennobler
ennuye973753ennuye_
ennuyee1084153ennuyee
enrobe86610793enrobe_
enrobed10279253enrobed
enrobers10236953enrobers
enrobes92211113enrobes
enroller867183enroller
enskyed1532503enskyed
ensurer73011903ensurer
enter54726383en__ter
enterer72015633enterer
enticer91510423enticer
entoderm1175343entoderm
envier939673en_vier
envoy1156723envoy__
envoys1255143envoy_s
essayer1033943essayer
evoker13467913e_voker
exposer1637413exposer
eyer76127283e___yer
foyer116416553__foyer
incomer1169943incomer
injurer14318473injurer
inlayer1036933inlayer
intoner7811673intoner
invoker1435363invoker
joker165715893__joker
joyed164811833__joyed
knower1337083kn_ower
nooser65517823_nooser
noter55025643_n_oter
oyer75927653___oyer
reenjoyed2042533reenjoyed
snooker113910303snooker
snooper93511533snooper
snoozer16409193snoozer
snorer64316763sn_orer
stroyer103510783stroyer
tenoner739683ten_oner
toyer84521553__toyer
tutoyer1033793tutoyer
uncover1239003uncover
undoer73113043undo_er
unenjoyed2041993unenjoyed
unsober967643unsober
venomer1237583ven_omer

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.406440125.6
2DLD Change Limit134027975.71623447.7
3Display Results97970.0332939.4
 (SQL Overall)178691976.15529031.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.