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

235 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
erses5582680(None) 
arses55733871arses
eases56041611eases
erases64425401erases
ernes55224811ernes
eroses65327051eroses
eses45336101e_ses
esses56422971esses
perses85428061perses
verses94223761verses
aeries64737782aeries
apses76823912apses
ares45871022ar_es
arises65233802arises
arles56735742arles
arse46539272arse_
arsis55722422arsis
asses55629282asses
bases75644352bases
bermes106023002bermes
beses75830722beses
birses84717732birses
bises75435622bises
braes75735052braes
brees75632552brees
bries74942152bries
brises84927612brises
broses86524402broses
burses84425512burses
buses75936012buses
carses85233652carses
cases75048382cases
ceases84427072ceases
censes83721802censes
ceres75540012cer_es
cerises94722252cerises
certes84623082certes
ceruses93716232ceruses
cesses84221362cesses
corses84433462corses
coses76949492coses
crases85532312crases
cress75022832cress
cries75438402cries
crises84529432crises
cruses88127712cruses
curses85328272curses
doses65938502doses
drees65628522drees
dress65319832dress
dries64733672dries
druses75517252druses
ease45042332ease_
eased65430402eased
easel54521112easel
easels65914552easels
easies64126632easies
easts57530322easts
eaves85231992eaves
eches106322162eches
edges75718722edges
egises7312492egises
egress73310432egress
ekes86726602e_kes
else45923082else_
elves85118742elves
emes65434662e_mes
emeses86114962emeses
ensues63313812ensues
epees75219832epees
eposes84418782eposes
eras45441502er_as
erase54925492erase_
erased74816752erased
eraser64216332eraser
erasers74413942erasers
ere36352772er_e_
ergs55523812er_gs
erne46727422erne_
erns45428222er_ns
erodes74819882erodes
eros45238452er_os
erose55727272erose_
erred65915672erred
errs45622532er_rs
ers36046282er__s
erst47436432ers_t
esnes54817362esnes
ess36030882e_s_s
eves76230462e_ves
ewes76328702e_wes
exes116530812e_xes
eyases94513682eyases
eyes75837882e_yes
eyres84921772eyres
eyries93816812eyries
feases95422922feases
feres86038182fer_es
fesses94820252fesses
frees86131392frees
fries85535602fries
frises94124272frises
froes86126692froes
fuses85628422fuses
gases65633992gases
gorses74723292gorses
grees65132472grees
grues65721962grues
hearses104414532hearses
heres86245902her_es
heroes94923822heroes
herpes115517322herpes
horses94729342horses
hoses85443172hoses
ires45639282ir_es
irises64221172irises
jersey1636332jersey
jerseys1733242jerseys
jesses135215952jesses
kermes124616122kermes
kernes104717522kernes
kersey1336782kersey
kerseys1433992kerseys
krises105016082krises
lases54944762lases
leases65428112leases
lenses64620892lenses
leses54930812leses
loses56742012loses
lyses84518252lyses
marses84827112marses
menses84222452menses
merces105720742merces
merdes94518602merdes
meres75143572mer_es
merges94122482merges
merises93421422merises
merles85322762merles
messes84924342messes
mises74740562mises
muses75134302muses
nerves94216192nerves
nesses64718322nesses
noses55435642noses
nurses63919352nurses
oases55330982oases
ores46056682or_es
orles55326212orles
oses46641512_oses
parses85534702parses
pases75346502pases
peases85229472peases
peises84125042peises
peres76246642per_es
perse75429522perse_
peruses94018162peruses
poses74642762poses
prases84429022prases
prees75937172prees
press75425952press
pries74339532pries
prises84133172prises
proses84733472proses
purses84826372purses
puses75532202puses
rases55447212rases
redes65139122redes
rees45364192_rees
reges65628782reges
rerises73525882rerises
res35565042_r_es
resee54336332resee
resees63827482resees
reset55051862reset
resets65427612resets
resew84519502resew
resews94814172resews
reshes94124362reshes
rests54935872rests
reuses66025522reuses
rexes124526952rexes
rises55244042rises
roes45954132_roes
roses56445772roses
rues46044482_rues
ruses56136582ruses
ryes75529352_ryes
seises64026712seises
senses63923942senses
sepses84515882sepses
seres55448892ser_es
serges74225962serges
series64540972series
serves94423652serves
sises55233832sises
teases65426272teases
tenses64722552tenses
terces83921412terces
ternes65422902ternes
terse55026822terse_
terser67317822terser
tersest71713992tersest
torses64727952torses
trees55835762trees
tres46542902tr_es
tress55423162tress
tries55742812tries
trues54925322trues
urases63723562urases
urges64619912urges
uruses63616502uruses
uses44931112_uses
vases84626262vases
verges104320172verges
vermes115019142vermes
verse84723582verse_
versed104515512versed
verser94516962verser
versers103813512versers
verset94327322verset
versets103913092versets
versos93812802versos
verstes104014272verstes
versts93914732versts
versus94211142versus
verves124617882verves
vises84427772vises
wises85633192wises
worses95522952worses
wries85827742wries
xeroses143612822xeroses
xeruses143010752xeruses
yeses85119322yeses
yesses93615812yesses
zeroes154314342zeroes

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.1101624463.6
2DLD Change Limit538002351.96627365.2
3Display Results2352350.0802937.5
 (SQL Overall)1786912352.15682880.8
 
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.