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

133 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
esnes5481736(None) 
ernes55224811ernes
eses45336101es_es
esne47018791esne_
esses56422971esses
mesnes85216211mesnes
acnes75922622acnes
anes45255932_anes
ashes86230612ashes
asses55629282asses
banes74945582banes
benes75536232benes
bennes86019012bennes
beses75830722bes_es
bines76946792bines
bones76446532bones
canes75350372canes
censes83721802censes
cesses84221362cesses
cines75239682cines
cones76457422cones
denes65639722denes
dines66449152dines
dunes65332172dunes
dynes95917582dynes
eases56041612eases
easies64126632easies
eaves85231992eaves
eches106322162eches
edges75718722edges
ekes86726602e_kes
elves85118742elves
emes65434662e_mes
ends56528522e_nds
engs56121392e_ngs
ens37245922e_n_s
ensues63313812ensues
eons46638712eon_s
eosines73718292eosines
epees75219832epees
erne46727422erne_
erns45428222ern_s
erses55826802erses
esker94412982esker
eskers105312222eskers
espies83716802espies
ess36030882es__s
ester54727712ester
esters64627732esters
etnas54713932etnas
evens84817102evens
eves76230462e_ves
ewes76328702e_wes
exes116530812e_xes
exines135715802exines
eyes75837882e_yes
eyne76322462eyne_
eyres84921772eyres
fanes84639892fanes
fesses94820252fesses
fines86644262fines
genes65133092genes
gestes75721392gestes
hones88144492hones
isles54220562isles
janes124928122janes
jesses135215952jesses
jones125028182jones
kanes95529372kanes
kernes104717522kernes
kines95039132kines
lanes54946792lanes
lenes54738522lenes
lenses64620892lenses
leones64417722leones
leses54930812les_es
lines57054572lines
lunes55337772lunes
manes76648952manes
menses84222452menses
meshes115019442meshes
mesne75116292mesne_
messes84924342messes
mines75651952mines
nenes55329672nenes
nesses64718322nesses
nines55937342nines
nones55639132nones
ones46146532_ones
oses46641512os_es
panes76148692panes
penes75839222penes
peones83821042peones
pines76048862pines
pones74547042pones
resees63827482resees
reshes94124362reshes
runes55530222runes
sanes55649072sanes
sees45361052_sees
seines65029902seines
semes75731582semes
sends65528242sends
sene46848052sene_
sense55526822sense
senses63923942senses
seres55448892seres
sexes126126222sexes
shes75734352_shes
sines55954822sines
sned56026052_sned
sneds65715352_sneds
snyes85012752_snyes
sones55444142sones
sues46247652_sues
tenses64722552tenses
ternes65422902ternes
testes65125822testes
tines54848422tines
tones56048662tones
tunes55332192tunes
tynes85920302tynes
uses44931112us_es
usnea539392usnea
usneas638332usneas
vanes85130972vanes
vines85137642vines
wanes85040882wanes
wines85546862wines
yeses85119322yes_es
yesses93615812yesses
zines145232652zines
zones145528042zones

Search took 3 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.0931921408.6
2DLD Change Limit538001332.50021520.0
3Display Results1331330.0801662.5
 (SQL Overall)1786911332.67366850.4
 
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.