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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
enols5471840(None) 
enol45823821enol_
enows85115491enows
enrols61213381enrols
anils56326722anils
anoas57226492anoas
anole55330382anole
anoles64827432anoles
awols84713522awols
benzols1836672benzols
cols66553082_cols
cools75632632cools
diols65521012diols
dols56943052_dols
earls56127512earls
ebons74316092ebons
eels46536742e_els
egos55821652ego_s
ells46431352e_lls
els37645722e__ls
endows104610422endows
ends56528522en_ds
enfold10137612enfold
enfolds11136252enfolds
engs56121392en_gs
enjoys1644602enjoys
enoki9268872enoki
enokis103010272enokis
enolase7310192enolase
enolic8413352enolic
enorm74415642enorm
enosis63816422enosis
enow77819872eno_w
enrol51014282enrol_
enroll61110072enroll
enrolls7108092enrolls
ens37245922en__s
ensouls736032ensouls
entoils7810732entoils
envois988702envois
envoys1255142envoys
eons46638712e_ons
epos66723732epo_s
eros45238452ero_s
evils84114262evils
exons125813342exons
extols1337682extols
fools86824202fools
gaols66717572gaols
genoas74013622genoas
genoms94412482genoms
hols76946292_hols
idols65514132idols
indols74714202indols
kenos95220622keno_s
ketols104210762ketols
knobs11519712knobs
knoll9389602knoll
knolls10367412knolls
knops115911812knops
knots95614722knots
knows124912412knows
lenos56024862leno_s
metols84115772metols
mols65948572_mols
mools76027172mools
neons55818682neons
nerols6914892nerols
nils46132452_nils
nobs66436902_nobs
nods55838222_nods
noels56418702_noels
noes45845392_noes
nogs56534612_nogs
noils55024332_noils
nolo46229312_nolo
nolos54423352_nolos
noms65636402_noms
nos38859322_no_s
nous46136982_nous
nows75738232_nows
obols73715862obols
onos46229002ono_s
phenols1238102phenols
pols66044562_pols
pools74427702pools
senors63620792senors
snobs74716152snobs
snogs66017492snogs
snools65715882snools
snots55225122snots
snows84719892snows
sols45448162_sols
tenons62916602tenons
tenors63217752tenors
tools55325242tools
venoms114211212venoms
venous93713192venous
viols86118102viols
wools84421462wools
xenons132710482xenons

Search took 4 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 Filter178691538000.626285448.9
2DLD Change Limit538001012.70319903.8
3Display Results1011010.0303366.7
 (SQL Overall)1786911013.35953197.7
 
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.