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

209 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
yeses8511932(None) 
beses75830721beses
cyeses11510121cyeses
eses45336101_eses
leses54930811leses
yesses93615811yesses
aedes64625142aedes
apses76823912apses
arses55733872arses
asses55629282asses
bases75644352bases
bees65453382be_es
benes75536232benes
beset76739132beset
besets85718802besets
bests75932612bests
bises75435622bises
buses75936012buses
cases75048382cases
ceases84427072ceases
cedes84927322cedes
cees65941592ce_es
censes83721802censes
cepes94424462cepes
ceres75540012ceres
cess65326052ces_s
cesses84221362cesses
cetes75731102cetes
coses76949492coses
cyesis1148572cyesis
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
desex13311982desex
desks105913072desks
dexes135224512dexes
dieses75218692dieses
doses65938502doses
eases56041612eases
ekes86726602_ekes
emes65434662_emes
emeses86114962emeses
erses55826802erses
esnes54817362_esnes
ess36030882_es_s
esses56422972esses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyases94513682eyases
eyes75837882_eyes
eyres84921772eyres
feases95422922feases
feces105625362feces
fees76450602fe_es
femes105626222femes
feres86038182feres
fess76529162fes_s
fesse86116332fesse
fesses94820252fesses
fests85828042fests
fetes85630142fetes
fezes175220022fezes
fuses85628422fuses
gases65633992gases
gees55647882ge_es
genes65133092genes
gestes75721392gestes
gests66028812gests
hebes105521672hebes
hemes105031082hemes
heres86245902heres
hests85829932hests
hexes155123042hexes
hoses85443172hoses
jees115938542je_es
jefes155613672jefes
jess116022032jes_s
jesse126012832jesse
jesses135215952jesses
jests125922452jests
jetes124922842jetes
kexes166216812kexes
lases54944762lases
leases65428112leases
lees45455882le_es
leges64427282leges
lenes54738522lenes
lenses64620892lenses
less45635102les_s
lexes127225262lexes
loses56742012loses
lyases95211872lyases
lyses84518252lyses
memes94927702memes
menses84222452menses
meres75143572meres
mesas76823202mesas
meshes115019442meshes
mesnes85216212mesnes
mess65932432mes_s
messes84924342messes
metes74736212metes
mezes167719262mezes
mises74740562mises
muses75134302muses
myases113711552myases
myoses114013842myoses
nenes55329672nenes
ness45526562nes_s
nesses64718322nesses
nests55728002nests
neves87021872neves
noses55435642noses
oases55330982oases
oses46641512_oses
oyesses1037332oyesses
oyezes1835052oyezes
pases75346502pases
peases85229472peases
pedes85327282pedes
pees65257372pe_es
peises84125042peises
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
perses85428062perses
pesos77221622pesos
pests75933272pests
poses74642762poses
puses75532202puses
pyoses114314302pyoses
rases55447212rases
redes65139122redes
rees45364192re_es
reges65628782reges
resee54336332resee
resees63827482resees
reset55051862reset
resets65427612resets
resew84519502resew
resews94814172resews
reshes94124362reshes
rests54935872rests
reuses66025522reuses
rexes124526952rexes
rises55244042rises
roses56445772roses
ruses56136582ruses
sees45361052se_es
seises64026712seises
semes75731582semes
senses63923942senses
sepses84515882sepses
seres55448892seres
sexes126126222sexes
sises55233832sises
teases65426272teases
tees45353582te_es
teles54536002teles
tenses64722552tenses
testes65125822testes
tests56530192tests
theses96517972theses
tmeses85712242tmeses
tyees86019452tye_es
uses44931112_uses
vases84626262vases
vees75439432ve_es
veges94118862veges
verses94223762verses
vests85325982vests
vexes155719122vexes
vises84427772vises
wees76249122we_es
wests85727002wests
wises85633192wises
yeahs115214552yeahs
yeans86624882yeans
years84527672years
yeas78638422ye_as
yeasts96413052yeasts
yechs136112582yechs
yeggs10608162yeggs
yelks126413622yelks
yells85821942yells
yelps105712992yelps
yens75832262ye_ns
yentes95517602yentes
yeps95924402ye_ps
yerks125416562yerks
yes66250612y__es
yessed104511162yessed
yester93417982yester
yetis85418392yetis
yetts86715132yetts
yeuks125110092yeuks
yews105323962ye_ws
yikes125117752yikes
yipes106017842yipes
yokes125223022yokes
yores85031322yores
yowes114926372yowes
yules84521582yules
zees136331892ze_es
zests145419742zests

Search took 2 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 Limit538002091.62333148.5
3Display Results2092090.0633317.5
 (SQL Overall)1786912091.779100444.6
 
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.