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

218 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
tyer7532339(None) 
dyer85522111dyer
eyer76127281eyer
oyer75927651oyer
tier44936141tier
toyer84521551toyer
tuyer85414291tuyer
twyer11558521twyer
tye65837441tye_
tyee75131421tyee
tyers86220051tyers
tyes76433371tyes
tyre75428251tyre
ager55935842ager
aper66336232aper
aver75931882aver
aye67151762aye_
ayes76543512ayes
beer65635992beer
bier65531822bier
buyer105013092buyer
bye86134592bye_
byes95230532byes
byre95023852byre
coyer105222842coyer
cyber124910382cyber
cyder114611132cyder
deer56739022deer
doer57734702doer
dryer95111462dryer
dye75334842dye_
dyed96720762dyed
dyers96617132dyers
dyes85331892dyes
eger55923562eger
er28345142__er
ether84518772ether
ever77027692ever
ewer77523982ewer
eye65539772eye_
eyed86623232eyed
eyen76223662eyen
eyers86521332eyers
eyes75837882eyes
eyre75525252eyre
fer66646122_fer
feyer115014522feyer
flyer114916252flyer
foyer116416552foyer
fryer115913432fryer
gayer94519192gayer
goer56827102goer
gyre84722762gyre
hayer114620242hayer
her66547812_her
hoer76533982hoer
hyper135213902hyper
ither84617602ither
jeer115426462jeer
kier86526802kier
kyar116916842kyar
kye107327272kye_
kyes115124932kyes
layer84626472layer
leer46239352leer
lier45942462lier
lye66533412lye_
lyes75530832lyes
lyre75623792lyre
omer67028392omer
other84219102other
otter54423972otter
over77227342over
oyers87620882oyers
oyes74940132oyes
oyez166020352oyez
payer105125722payer
peer66238352peer
per56353092_per
pier66035292pier
plyer106214332plyer
pryer104415312pryer
pye86432502pye_
pyes95528992pyes
pyre94925552pyre
ruer46127562ruer
rye66032542rye_
ryes75529352ryes
sayer84926552sayer
seer45547042seer
ser36752402_ser
shyer114714782shyer
slyer85515122slyer
stayer94516482stayer
steer55423862steer
stye76218972stye_
styed95815482styed
styes86316522styes
styler94013302styler
suer45334032suer
taber73825822taber
tae38267052tae_
tael46030712tael
tahr75217152tahr
taker95229002taker
taler56034862taler
tamer75230102tamer
taper74829772taper
tar37570692t_ar
tare45957622tare
tater54138612tater
tawer85223442tawer
taxer125019362taxer
tea37353322t_ea
tear45242882tear
ted46446562t_ed
tee38366872t_ee
teed55439262teed
teel46335802teel
teem66132602teem
teen45938202teen
tees45353582tees
teg45741622t_eg
tel35647902t_el
ten35856112t_en
term66233152t_erm
tern46134802t_ern
tet39274982t_et
tew66640152t_ew
the67436052the_
thee78039062thee
their85512152their
them97427042them
then78429692then
there87527392there
therm106018022therm
thew108226232thew
they107223752they
thir76420542thir
tie36557532tie_
tied55535212tied
tiers55526522tiers
ties45248312ties
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tire46143352tire
titer55430612titer
toe310166852toe_
toea46732332toea
toed56137042toed
toes46956442toes
toker95924912toker
toner55336242toner
toper75231022toper
tor39261682t_or
tore47359322tore
torr45630902torr
toter55932132toter
tour45530372tour
tower85729202tower
toyed96019802toyed
toyers95516332toyers
tree47745812tree
tref77030992tref
trek86222312trek
tres46542902tres
tret46653532tret
trey77228792trey
trier54328532trier
truer54916642truer
tsar47819802tsar
tuber75420682tuber
tuner56022682tuner
tuyere9408612tuyere
tuyers94612562tuyers
twee76827082twee
twerp10398412twerp
twier84713292twier
twyers12497412twyers
tyees86019452tyees
tyin76424002tyin
tyke115720502tyke
tykes125817062tykes
tyne76325052tyne
tyned95915012tyned
tynes85920302tynes
type96223742type
typed115815452typed
types105721062types
typey135511882typey
typier1137332typier
typo95418122typo
typp115812782typp
typy126013042typy
tyred95816432tyred
tyres84725232tyres
tyro76622362tyro
tzar136315372tzar
user45023002user
utter54218762utter
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 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.0802233637.5
2DLD Change Limit298722180.95331345.2
3Display Results2182180.0464739.1
 (SQL Overall)1786912181.079165608.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.