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

187 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
eyer7612728(None) 
dyer85522111dyer
eger55923561eger
ever77027691ever
ewer77523981ewer
eye65539771eye_
eyed86623231eyed
eyen76223661eyen
eyers86521331eyers
eyes75837881eyes
eyre75525251eyre
feyer115014521feyer
oyer75927651oyer
tyer75323391tyer
ager55935842ager
aper66336232aper
aver75931882aver
aye67151762aye_
ayes76543512ayes
beer65635992beer
bier65531832bier
buyer105013092buyer
bye86134592bye_
byes95230532byes
byre95023852byre
ceder85322232ceder
coyer105222842coyer
cyber124910382cyber
cyder114611132cyder
deer56739022deer
defer94619752defer
deter65028042deter
doer57734702doer
dryer95111462dryer
dye75334842dye_
dyed96720762dyed
dyers96617132dyers
dyes85331892dyes
eager65526962eager
ear36867882e_ar
eater54639842eater
edger75215932edger
eek77935102e_ek
eel37946842e_el
eery76129622e_ery
egers65120372egers
egger74414402egger
eider64624742eider
eke75630092eke_
eked96718022eked
ekes86726602ekes
elder64020022elder
elver85216242elver
ember95516802ember
eme55837182eme_
emeer74815362emeer
emery104814332emery
emes65434662emes
emeu66723432emeu
emir65918702emir
emmer94314462emmer
ender64325862ender
enter54726382enter
epee64628502epee
er28345142__er
ere36352772ere_
err35626532e_rr
eses45336102eses
esker94412982esker
ester54727712ester
ether84518772ether
eve66331162eve_
even75222272even
evert84929512evert
every115215452every
eves76230462eves
ewe66630982ewe_
ewers86018822ewers
ewes76328702ewes
exec135313942exec
exed125420592exed
exert124624142exert
exes116530812exes
eyas76427432eyas
eyebar1135322eyebar
eyne76322462eyne
eyra76217552eyra
eyres84921772eyres
eyrir8359652eyrir
eyry106315882eyry
fer66646122_fer
fever115617952fever
fewer115216122fewer
flyer114916252flyer
foyer116416552foyer
fryer115913432fryer
gayer94519192gayer
geyser1036512geyser
goer56827102goer
greyer104510092greyer
gyre84722762gyre
hayer114620242hayer
heder95623632heder
her66547812_her
hewer115719932hewer
hexer155116682hexer
hoer76533982hoer
hyper135213902hyper
jeer115426462jeer
keyed1369382keyed
kier86526802kier
kyar116916842kyar
kye107327272kye_
kyes115124932kyes
layer84626472layer
leer46239352leer
leger65721502leger
leper74820742leper
lever85125162lever
lier45942462lier
lye66533412lye_
lyes75530832lyes
lyre75623792lyre
merer75126232merer
meter75130322meter
never86218642never
newer85717462newer
obeyer1135892obeyer
omer67028392omer
over77227342over
oyers87620882oyers
oyes74940132oyes
oyez166020352oyez
payer105125722payer
peer66238352peer
per56353092_per
peter74427592peter
pier66035292pier
plyer106214332plyer
preyer114413732preyer
pryer104415312pryer
pye86432502pye_
pyes95528992pyes
pyre94925552pyre
refer84822142refer
ruer46127562ruer
rye66032542rye_
ryes75529352ryes
sayer84926552sayer
seder64826752seder
seer45547042seer
ser36752402_ser
serer55935502serer
sever85426052sever
sewer84426212sewer
shyer114714782shyer
slyer85515122slyer
suer45334032suer
tier44936142tier
toyer84521552toyer
tuyer85414292tuyer
twyer11558522twyer
tye65837442tye_
tyee75131422tyee
tyers86220052tyers
tyes76433372tyes
tyre75428252tyre
user45023002user
veer76229572veer
vexer155513522vexer
vier75428152vier
weber10313522weber
weer75535092weer
wryer11489302wryer
wye96331972wye_
wyes105727502wyes
yar67253832_yar
ye57650062_ye_
yea66445752_yea
year76534252year
yeh97135772_yeh
yen66847382_yen
yep86638962_yep
yerk116222082_yerk
yes66250612_yes
yet66960692_yet
yew96436292_yew

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 Filter178691298720.0602978183.3
2DLD Change Limit298721871.01629401.6
3Display Results1871870.0464065.2
 (SQL Overall)1786911871.122159261.1
 
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.