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

278 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
wyes10572750(None) 
ayes76543511ayes
byes95230531byes
dyes85331891dyes
eyes75837881eyes
kyes115124931kyes
lyes75530831lyes
oyes74940131oyes
pyes95528991pyes
ryes75529351ryes
tyes76433371tyes
waes76048601waes
wees76249121wees
woes76440661woes
wye96331971wye_
wyles114615321wyles
wyns105717031wyns
wytes114113431wytes
yes66250611_yes
abyes105518532abyes
aces67645092aces
ages55844592ages
ales47067102ales
anes45255932anes
apes66047432apes
ares45871022ares
ates45047922ates
aves76142602aves
awes76037552awes
axes117337852axes
aye67151762aye_
ays67050292ay_s
bees65453382bees
bes56557432_bes
beys913829552beys
bye86134592bye_
byres104421382byres
bys85229462by_s
bytes105217492bytes
cees65941592cees
cues65438982cues
cymes1210118922cymes
dees56356632dees
deys85027472deys
dies55653522dies
does56554472does
dues56045502dues
dye75334842dye_
dyed96720762dyed
dyer85522112dyer
dyers96617132dyers
dykes135215572dykes
dynes95917582dynes
ekes86726602ekes
emes65434662emes
es29048222__es
eses45336102eses
eves76230462eves
ewes76328702ewes
exes116530812exes
eyas76427432eyas
eye65539772eye_
eyed86623232eyed
eyen76223662eyen
eyer76127282eyer
eyers86521332eyers
eyres84921772eyres
fees76450602fees
fes66551672_fes
foes76543442foes
fyces139813642fyces
fykes156312692fykes
gaes56348032gaes
gees55647882gees
gies55641422gies
goes55644092goes
gybes115012722gybes
gyms107514592gyms
gyps105115022gyps
gyres94820322gyres
gyves125711552gyves
haes77651022haes
hes66654202_hes
hies74842832hies
hoes75755732hoes
hues75235232hues
hypes135818672hypes
hyps125418412hyps
ices66129642ices
ides57734232ides
ires45639282ires
jees115938542jees
joes116635892joes
kaes85734062kaes
keys116322162keys
kues86426772kues
kye107327272kye_
kytes125012912kytes
lees45455882lees
les35663072_les
leys76430182leys
lies46454192lies
lues45943552lues
lye66533412lye_
lyres85019962lyres
lyse76320592lyse
lyses84518252lyses
maes66948402maes
mycs115314292mycs
noes45845392noes
obes66036832obes
odes57243242odes
oes35866192_oes
okes84936342okes
oles46453472oles
ones46146532ones
opes65942612opes
ores46056682ores
oses46641512oses
owes75137102owes
oxes116530722oxes
oyer75927652oyer
oyers87620882oyers
oyez166020352oyez
pees65257372pees
pes57259782_pes
pies66949602pies
pyas96225702pyas
pye86432502pye_
pyres105523882pyres
pyxes175911402pyxes
rees45364192rees
res35565042_res
roes45954142roes
rues46044482rues
ryas77224612ryas
rye66032542rye_
rykes125513032rykes
sees45361052sees
shes75734352shes
snyes85012752snyes
styes86316522styes
sues46247652sues
syces106416462syces
sykes124816862sykes
tees45353582tees
ties45248312ties
toes46956442toes
tres46542902tres
twaes86513662twaes
twyer11558522twyer
twyers12497412twyers
tye65837442tye_
tyee75131422tyee
tyees86019452tyees
tyer75323392tyer
tyers86220052tyers
tykes125817062tykes
tynes85920302tynes
types105721062types
tyres84725232tyres
ukes86122812ukes
uses44931112uses
utes45930882utes
vees75439432vees
vies75238622vies
voes75432822voes
wabs97337232wabs
wades95634142wades
wads87343142wads
wae67556952wae_
wages95330932wages
wags86140552wags
wakes126633652wakes
wales86142832wales
wames106432802wames
wanes85040882wanes
wans76452272wans
waps96642082waps
wares88250582wares
wars78659802wars
was68767562w_as
wats77555882wats
waves115633922waves
waws106834902waws
waxes155825502waxes
ways107737952ways
we57043452w_e_
web85735562w_eb
webs96622122webs
wed75843622w_ed
weds86628932weds
wee66760812w_ee
weed85637512weed
weeds95222212weeds
week116428152week
weeks125017862weeks
weel75834082weel
ween75835462ween
weens85224052weens
weep95131652weep
weeps104120562weeps
weer75535092weer
weest85026772weest
weet75254152weet
weets85427722weets
wen66249602w_en
wens76337932wens
west75748082w_est
wet65966622w_et
wets75940292wets
whee105429592whee
when105723042when
whens114618762whens
whet105133782whet
whets115019612whets
whew137618782whew
whews145114492whews
whey135018712whey
wheys145911552wheys
whys137011662whys
wides94832822wides
wifes114522562wifes
wigs84931252wigs
wiles85437872wiles
wines85546862wines
wins75949172wins
wipes104827082wipes
wires86034912wires
wis66552332w_is
wise75737342wise
wises85633192wises
wiss75630542wiss
wites85536962wites
wits76044872wits
wives115328922wives
wizes174723342wizes
woe66651242woe_
wogs86531402wogs
woks116224902woks
wons74942042wons
woos76238802woos
wops96634152wops
wos66953532w_os
wots76342892wots
wows104633492wows
wren78221682wren
wrens85016242wrens
wrest84925432wrest
wries85827742wries
wryer11489302wryer
wryest12429112wryest
wuss75219332wuss
wych154011882wych
wyches17387912wyches
wyle105519382wyle
wyled124611842wyled
wyn95921442wy_n
wynd116114462wynd
wynds126310372wynds
wynn105811292wynn
wynns11517472wynns
wyte106018642wyte
wyted12529472wyted
ye57650062_ye_
yea66445752_yea
yeas78638422_yeas
yeh97135772_yeh
yen66847382_yen
yens75832262_yens
yep86638962_yep
yeps95924402_yeps
yet66960692_yet
yew96436292_yew
yews105323962_yews
ywis105313102ywis
zees136331892zees
zymes1924712942zymes

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.733243780.4
2DLD Change Limit298722781.50019914.7
3Display Results2782780.1561782.1
 (SQL Overall)1786912782.38974797.4
 
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.