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

311 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
ewes7632870(None) 
awes76037551awes
ekes86726601ekes
emes65434661emes
eses45336101eses
eves76230461eves
ewe66630981ewe_
ewer77523981ewer
ewers86018821ewers
exes116530811exes
eyes75837881eyes
owes75137101owes
wees76249121wees
aces67645092aces
aedes64625152aedes
ages55844592ages
ales47067102ales
anes45255932anes
apes66047432apes
ares45871022ares
ates45047922ates
aves76142602aves
awe67746622awe_
awed88436032awed
awee76336642awee
awls75926092awls
awns75324432awns
axes117337852axes
ayes76543512ayes
bees65453382bees
benes75536232benes
bes56557432_bes
beses75830722beses
byes95230532byes
cedes84927332cedes
cees65941592cees
cepes94424462cepes
ceres75540012ceres
cetes75731102cetes
cues65438982cues
cwms11439572cwms
dees56356632dees
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dewed105020302dewed
dews86230602dew_s
dexes135224512dexes
dies55653522dies
does56554472does
dues56045502dues
dyes85331892dyes
ears46356592ears
ease45042332ease
eases56041612eases
eats47054872eats
eaves85231992eaves
ebbs82411992ebbs
eches106322162eches
ecus65421462ecus
edges75718742edges
edhs86212102edhs
eds46638922e_ds
eek77935102e_ek
eel37946842e_el
eels46536742eels
effs105114032effs
efs66829602e_fs
efts76519482efts
eger55923572eger
egers65120372egers
egest65222342egest
eggs66516152eggs
egis56520652egis
egos55821652egos
eke75630092eke_
eked96718022eked
elds56324852elds
elks85820032elks
ells46431352ells
elms67322702elms
els37645722e_ls
else45923082else
elves85118742elves
eme55837182eme_
emeu66723432emeu
emeus76913332emeus
ems56435492e_ms
emus66821682emus
ends56528522ends
engs56121392engs
ens37245922e_ns
eons46638712eons
epee64628502epee
epees75219832epees
epos66723732epos
eras45441502eras
ere36352772ere_
ergs55523812ergs
ernes55224812ernes
erns45428222erns
eros45238452eros
errs45622532errs
ers36046282e_rs
erses55826802erses
es29048222__es
esnes54817362esnes
ess36030882e_ss
esses56422972esses
etas46432272etas
eths76619522eths
etwee84115332etwee
etwees9348792etwees
eve66331162eve_
even75222272even
evens84817102evens
ever77027692ever
exec135313942exec
execs14539722execs
exed125420592exed
eyas76427432eyas
eye65539772eye_
eyed86623232eyed
eyen76223662eyen
eyer76127282eyer
eyers86521332eyers
eyres84921772eyres
feces105625362feces
fees76450602fees
femes105626222femes
feres86038182feres
fes66551672_fes
fetes85630142fetes
fewer115216122fewer
fewest12311662fewest
fezes175220022fezes
foes76543442foes
gaes56348032gaes
gees55647882gees
genes65133092genes
gies55641422gies
goes55644092goes
haes77651022haes
hebes105521672hebes
hemes105031082hemes
heres86245902heres
hes66654202_hes
hewed125619432hewed
hewer115719932hewer
hewers123715272hewers
hews105631572hew_s
hexes155123042hexes
hies74842832hies
hoes75755732hoes
howes114730262howes
hues75235232hues
ices66129642ices
ides57734232ides
ires45639282ires
iwis77117012iwis
jees115938542jees
jefes155613672jefes
jetes124922842jetes
jewed165114832jewed
jewel156711702jewel
jewels16508612jewels
jews145822082jew_s
joes116635892joes
kaes85734062kaes
kexes166216822kexes
krewes1337922krewes
kues86426772kues
kyes115124932kyes
lees45455882lees
leges64427292leges
lenes54738522lenes
les35663072_les
leses54930812leses
lewis85315842lewis
lexes127225262lexes
lies46454192lies
lowes85732462lowes
lues45943552lues
lwei75312642lwei
lweis8458692lweis
lyes75530832lyes
maes66948402maes
memes94927702memes
meres75143572meres
metes74736212metes
mewed115218012mewed
mewls105813232mewls
mews96629332mew_s
mezes167719262mezes
nenes55329672nenes
neves87021872neves
newel86114132newel
newels93710822newels
newer85717462newer
newest9314212newest
newies91014072newies
news76127372new_s
newts86015282newts
noes45845392noes
obes66036832obes
odes57243242odes
oes35866192_oes
okes84936342okes
oles46453472oles
ones46146532ones
opes65942612opes
ores46056682ores
oses46641512oses
owe67041032owe_
owed86833872owed
owls76022932owls
owns76819582owns
owse76321622owse
oxes116530722oxes
oyes74940132oyes
pedes85327292pedes
pees65257372pees
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
pes57259782_pes
pewee10319972pewee
pewees11311392pewees
pews95731532pew_s
pies66949602pies
pyes95528992pyes
redes65139132redes
rees45364192rees
reges65628792reges
res35565042_res
rewed95425452rewed
reweds104412302reweds
rewet85135152rewet
rewets94617212rewets
rexes124526952rexes
roes45954142roes
rues46044482rues
ryes75529352ryes
sees45361052sees
semes75731582semes
seres55448892seres
sewed95325162sewed
sewer84426222sewer
sewers94719722sewers
sews75836022sew_s
sexes126126222sexes
shes75734352shes
sues46247652sues
tees45353582tees
teles54536002teles
tewed94718532tewed
tews76431642tew_s
ties45248312ties
toes46956442toes
tres46542902tres
twaes86513662twaes
twas76824082twas
twee76827082twee
twos76718022twos
tyes76433372tyes
ukes86122812ukes
uses44931112uses
utes45930882utes
vees75439432vees
veges94118872veges
vexes155719122vexes
vies75238622vies
voes75432822voes
waes76048602waes
was68767562_was
we57043452_we_
web85735562_web
webs96622122webs
wed75843622_wed
weds86628932weds
wee66760812_wee
weed85637512weed
weeds95222212weeds
week116428152week
weeks125017862weeks
weel75834082weel
ween75835462ween
weens85224052weens
weep95131652weep
weeps104120562weeps
weer75535092weer
weest85026772weest
weet75254152weet
weets85427722weets
wen66249602_wen
wens76337932wens
west75748082_west
wet65966622_wet
wets75940292wets
wis66552332_wis
woes76440662woes
wos66953532_wos
wyes105727502wyes
yes66250612_yes
yeses85119322yeses
yews105323962yew_s
yowes114926372yowes
ywis105313102ywis
zees136331892zees

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 Filter178691298720.530337152.8
2DLD Change Limit298723111.75017069.7
3Display Results3113110.1402221.4
 (SQL Overall)1786913112.42073839.3
 
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.