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

186 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
dyer8552211(None) 
deer56739021deer
doer57734701doer
dryer95111461dryer
dye75334841dye_
dyed96720761dyed
dyers96617131dyers
dyes85331891dyes
eyer76127281eyer
oyer75927651oyer
tyer75323391tyer
adder75419592adder
ager55935842ager
aper66336232aper
aver75931882aver
aye67151762aye_
ayes76543512ayes
beer65635992beer
bier65531832bier
buyer105013092buyer
bye86134592bye_
byes95230532byes
byre95023852byre
coyer105222842coyer
cyber124910382cyber
cyder114611132cyder
dare55848862dare
darer65230792darer
dater65332312dater
de37049542d_e_
dear55343602dear
deb66342692d_eb
dee47665822d_ee
deed65340902deed
deem75432892deem
deep76031882deep
deers64930522deers
dees56356632dees
deet57356582deet
def76546722d_ef
defer94619752defer
del46752752d_el
den47554342d_en
dere56845902d_ere
derm76031892d_erm
deter65028042deter
dev76033772d_ev
dew77139922d_ew
dex116936882d_ex
dey77243372d_ey
deys85027472deys
dicer85426422dicer
die46759652die_
died66137852died
diel59034602diel
dies55653522dies
diet57357532diet
diker105524552diker
dimer85625602dimer
diner65632902diner
dire56644142dire
direr64927072direr
diver94827802diver
doe47361952doe_
doers65225712doers
does56554472does
door56928512door
doper86128392doper
dor47253922d_or
dore56353302dore
dorr56627722dorr
doser66228562doser
doter65428622doter
dour56330432dour
dower95027702dower
doyen95014412doyen
dozer158419272dozer
drear65016902drear
dree56638322dree
dreg66821652dreg
drek96321082drek
drew86221672drew
drier64423962drier
dryers10449272dryers
due45249862due_
duel56729702duel
dues56045502dues
duet56446262duet
duper85519002duper
dure56341812dure
durr55624352durr
dyad96415452dyad
dyke126418182dyke
dyked145310952dyked
dykes135215572dykes
dykey16608672dykey
dyne85320932dyne
dynel9569852dynel
dynes95917582dynes
edger75215932edger
eger55923562eger
er28345142__er
ever77027692ever
ewer77523982ewer
eye65539772eye_
eyed86623232eyed
eyen76223662eyen
eyers86521332eyers
eyes75837882eyes
eyre75525252eyre
fer66646122_fer
feyer115014522feyer
flyer114916252flyer
foyer116416552foyer
fryer115913432fryer
gayer94519192gayer
goer56827102goer
gyre84722762gyre
hayer114620242hayer
her66547812_her
hoer76533982hoer
hyper135213902hyper
idler65015662idler
jeer115426462jeer
kier86526802kier
kyar116916842kyar
kye107327272kye_
kyes115124932kyes
layer84626472layer
leer46239352leer
lier45942462lier
lye66533412lye_
lyes75530832lyes
lyre75623792lyre
odder74515392odder
omer67028392omer
over77227342over
oyers87620882oyers
oyes74940132oyes
oyez166020352oyez
payer105125722payer
peer66238352peer
per56353092_per
pier66035292pier
plyer106214332plyer
pryer104415312pryer
pye86432502pye_
pyes95528992pyes
pyre94925552pyre
ruer46127562ruer
rye66032542rye_
ryes75529352ryes
sayer84926552sayer
seer45547042seer
ser36752402_ser
shyer114714782shyer
slyer85515122slyer
suer45334032suer
tier44936142tier
toyer84521552toyer
tuyer85414292tuyer
twyer11558522twyer
tye65837442tye_
tyee75131422tyee
tyers86220052tyers
tyes76433372tyes
tyre75428252tyre
udder76314282udder
user45023002user
veer76229572veer
vier75428152vier
weer75535092weer
wryer11489302wryer
wye96331972wye_
wyes105727502wyes
yar67253832_yar
ye57650062_ye_
yea66445752_yea
year76534252_year
yeh97135772_yeh
yen66847382_yen
yep86638962_yep
yerk116222082_yerk
yes66250612_yes
yet66960692_yet
yew96436292_yew

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.1401276364.3
2DLD Change Limit298721861.95315295.4
3Display Results1861860.0762447.4
 (SQL Overall)1786911862.16982384.0
 
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.