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

354 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
tier4493614(None) 
bier65531831bier
kier86526801kier
lier45942461lier
pier66035291pier
tie36557531tie_
tied55535211tied
tiers55526521tiers
ties45248311ties
tiger65718631tiger
tiler56131021tiler
timer75626041timer
tire46143351tire
titer55430611titer
trier54328531trier
twier84713291twier
tyer75323391tyer
vier75428151vier
ager55935842ager
aider65431132aider
aimer75926822aimer
air38058392ai_r
airer54927892airer
aiver85725162aiver
aper66336232aper
artier63419732artier
aver75931882aver
beer65635992beer
bider85728372bider
biers76225222biers
biker116022562biker
biner75930692biner
birr66022362birr
biter75030032biter
brier74527402brier
cider84723312cider
cire65836372cire
citer74827322citer
crier74724462crier
deer56739022deer
dicer85426422dicer
die46759652die_
died66137852died
diel59034602diel
dies55653522dies
diet57357532diet
diker105524552diker
dimer85625602dimer
diner65632902diner
dire56644142dire
direr64927072direr
diver94827802diver
doer57734702doer
dotier73917032dotier
drier64423962drier
dyer85522112dyer
eger55923562eger
eider64624742eider
er28345142__er
ether84518772ether
ever77027692ever
ewer77523982ewer
eyer76127282eyer
fer66646122_fer
fiar76427332fiar
fiber104921132fiber
fie67152442fie_
fief107331362fief
fiery114714792fiery
fifer115519972fifer
filer85433002filer
finer85431562finer
fir66744892fi_r
fire76245592fire
firer811229252firer
fiver116024942fiver
fixer154717832fixer
flier86023402flier
frier85225842frier
giber85417702giber
gie47149542gie_
gied64631982gied
gien56330022gien
gies55641422gies
giver94921202giver
goer56827102goer
heir77523802heir
her66547812_her
hider95024082hider
hie67652702hie_
hied85434042hied
hies74842832hies
hiker125119392hiker
hire75538962hire
hirer85423122hirer
hoer76533982hoer
icier74313752icier
ire36943172_ire
item65620382item
ither84617602ither
jeer115426462jeer
jiber145115702jiber
jiver155119052jiver
keir86217872keir
kief117128402kief
kiers95320092kiers
kir76535672ki_r
kiter95523212kiter
leer46239352leer
liar47229682liar
liber74723622liber
lie38264522lie_
lied55838092lied
lief76036992lief
lien45339802lien
liers55130402liers
lies46454192lies
lieu46534362lieu
lifer85822152lifer
liger65024472liger
liker95627062liker
liner55938922liner
lire47845292lire
liter54736342liter
liver85132962liver
matier84321522matier
metier83517692metier
mien65028362mien
miler75733062miler
mimer94825762mimer
miner76933542miner
mir57046772mi_r
mire66748232mire
miser75430402miser
miter75734792miter
mitier83620672mitier
mixer145017642mixer
nicer74618292nicer
niter55028972niter
oiler54628282oiler
omer67028392omer
osier53518012osier
other84219102other
otter54423972otter
over77227342over
oyer75927652oyer
peer66238352peer
per56353092_per
pie55457402pie_
pied75035362pied
piers75926332piers
pies66949602pies
piker115622842piker
piper96523192piper
pitier84019822pitier
plier75221282plier
prier75027762prier
ricer74726612ricer
rider65231302rider
riel46432382riel
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
ruer46127562ruer
seer45547042seer
ser36752402_ser
shier85428942shier
sieur5911892sieur
siker95326032siker
sir35746672si_r
sire46150412sire
siver85728612siver
sizer145521812sizer
skier95119592skier
slier54827242slier
spier75728032spier
steer55423862steer
stied65723032stied
sties55132982sties
stir45723242sti_r
stiver93915732stiver
suer45334032suer
taber73825822taber
tae38267052tae_
tael46030712tael
tahr75217152tahr
tailer63823732tailer
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
thief114516302thief
thir76420542thir
ti28448292ti__
tiara5315902tiara
tic56343462ti_c
tick106231222tick
ticker124321502ticker
tics65729632tics
tide55237372tide
tided76322512tided
tides64830152tides
tidier73515112tidier
tidy86822412tidy
tierce8339842tierce
tiered73613972tiered
tiff104727722tiff
tigers75616502tigers
tike85534482tike
tikes95628902tikes
tiki87620842tiki
til36350262ti_l
tile45451442tile
tiled64832942tiled
tilers63523492tilers
tiles55542102tiles
till45941202till
tiller64222532tiller
tils45739612tils
tilt46252422tilt
tilter63417692tilter
timber104012682timber
time66235012time
timed85223612timed
timers84420992timers
times75630822times
tin36362172ti_n
tinder73821802tinder
tine45855132tine
tinea54923152tinea
tined65434532tined
tines54848422tines
ting56139892ting
tinier63622232tinier
tinker103619922tinker
tinner64119962tinner
tins45251302tins
tint46758862tint
tinter63923642tinter
tiny76134632tiny
tip56551222ti_p
tipi69924432tipi
tipper103918412tipper
tips66436762tips
tired65228902tired
tires55437492tires
tirl45029922tirl
tiro46832362tiro
tis37056642ti_s
tit36771042ti_t
titers64526402titers
titfer9409522titfer
tither94920282tither
titi47130612titi
titre54619392titre
tits46145032tits
titter63421162titter
tivy1014516862tivy
toe310166852toe_
toea46732332toea
toed56137042toed
toes46956442toes
toiler63918282toiler
toker95924912toker
toner55336242toner
tonier65520712tonier
toper75231022toper
tor39261682t_or
tore47359322tore
torr45630902torr
toter55932132toter
tour45530372tour
tower85729202tower
toyer84521552toyer
tree47745812tree
tref77030992tref
trek86222312trek
tres46542902tres
tret46653532tret
trey77228792trey
tried65026912tried
triers64321522triers
tries55742812tries
trimer85717152trimer
triter65120592triter
truer54916642truer
tsar47819802tsar
tuber75420682tuber
tuner56022682tuner
tuyer85414292tuyer
twee76827082twee
twerp10398412twerp
twiers95410162twiers
twiner94012592twiner
twyer11558522twyer
tye65837442tye_
tyee75131422tyee
tyers86220052tyers
tyes76433372tyes
typier1137332typier
tyre75428252tyre
tzar136315372tzar
user45023002user
utter54218762utter
veer76229572veer
vie65447632vie_
vied86328632vied
viers85621952viers
vies75238622vies
view105917672view
viler86324162viler
viper105017302viper
weer75535092weer
weir76019922weir
wider94826352wider
wiper105421292wiper
wire75839812wire
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
wrier84521752wrier
yirr76513572yirr

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.0802233637.5
2DLD Change Limit298723542.17013765.9
3Display Results3543540.1732046.2
 (SQL Overall)1786913542.42373747.8
 
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.