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

214 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
trier5432853(None) 
brier74527401brier
crier74724461crier
drier64423961drier
frier85225841frier
prier75027761prier
tier44936141t_ier
tried65026911tried
triers64321521triers
tries55742811tries
trimer85717151trimer
triter65120591triter
truer54916641truer
twier84713291twier
wrier84521751wrier
aerier64823152aerier
airer54927892airer
airier64619362airier
arider74717742arider
ariel55228972ariel
armer76924442armer
artier63419732artier
bier65531832_bier
briar75718152briar
briber104714042briber
brie65837902brie_
brief105422602brief
briers85319732briers
briery114510772briery
bries74942152bries
briner84519042briner
burier84324652burier
cried84624282cried
criers83918582criers
cries75438402cries
direr64927072direr
dried75321382dried
driers74516732driers
dries64733672dries
driver104714492driver
dryer95111462dryer
eerier64320022eerier
firer811229252firer
flier86023402flier
freer86021242freer
friar85414272friar
fried95322912fried
friers94718932friers
fries85535602fries
frizer184011282frizer
fryer115913432fryer
gorier73719372gorier
grief95319782grief
griper94114612griper
hirer85423122hirer
icier74313752icier
kier86526802_kier
lier45942462_lier
mirier83918362mirier
orbier839992orbier
order65019362order
oriel54920422oriel
ormer75218372ormer
osier53518012osier
pier66035292_pier
plier75221282plier
pricer103918292pricer
pried84426862pried
priers84521192priers
pries74339532pries
primer105118682primer
prior74316172prior
prizer174714882prizer
pryer104415312pryer
ricer74726612_ricer
rider65231302_rider
riel46432382_riel
rifer84721982_rifer
rimer75429242_rimer
riper74328402_riper
riser55431052_riser
river85731692_river
ruer46127562_ruer
shier85428942shier
skier95119592skier
slier54827242slier
spier75728032spier
sprier84119062sprier
strider84315722strider
striker113714172striker
striper94514782striper
striver104315202striver
taber73825822taber
tailer63823732tailer
taker95229002taker
taler56034862taler
tamer75230102tamer
taper74829772taper
tardier859719992tardier
tarrier74323172tarrier
tarsier74119252tarsier
tarter64023562tarter
tartier74123262tartier
tater54138612tater
tawer85223442tawer
taxer125019362taxer
tearier73815612tearier
termer85717252termer
terrier73414962terrier
terser67317822terser
their85512152their
thief114516302thief
thir76420542thi_r
thriver13479122thriver
tidier73515112tidier
tie36557532t_ie_
tied55535212t_ied
tiers55526522t_iers
ties45248312t_ies
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tinier63622232tinier
tire46143352tire_
tired65228902tired
tires55437492tires
titer55430612titer
toiler63918282toiler
toker95924912toker
toner55336242toner
tonier65520712tonier
toper75231022toper
tories65435882tories
toter55932132toter
tower85729202tower
toyer84521552toyer
tracer84820232tracer
trader75218752trader
trailer73015392trailer
trainer73316792trainer
tree47745812tr_ee
treed65626732treed
treen55622752treen
trees55835762trees
tref77030992tr_ef
trek86222312tr_ek
tres46542902tr_es
tret46653532tr_et
trey77228792tr_ey
triac74116372triac
triad65217722triad
trial54926352trial
tribe74420272tribe
tribes85119022tribes
trice75127492trice
triced95518672triced
tricep103911072tricep
trices84826332trices
trick115420692trick
tricker134615522tricker
triene64316382triene
triens65417542triens
trifler103912152trifler
trig55528162tri_g
trigger9329162trigger
trigo65716052trigo
trigs65423062trigs
trijet133916552trijet
trike95320162trike
trikes105419492trikes
trill55122932trill
triller74215892triller
trim65329512tri_m
trimers94615142trimers
trimmer113610832trimmer
trims75021472trims
trine54734602trine
trined74920712trined
trines64132562trines
trio45233342tri_o
triol55521362triol
trios55528092trios
trip66830392tri_p
tripe75425382tripe
tripes85324872tripes
tripper113711922tripper
trips74923362trips
trite54730032trite
trivet93721882trivet
trover95014662trover
true46725852true_
trued65117692trued
trues54925322trues
tuber75420682tuber
tuner56022682tuner
turfier10249792turfier
turner63914612turner
tuyer85414292tuyer
twiers95410162twiers
twiner94012592twiner
twyer11558522twyer
tyer75323392t_yer
typier1137332typier
urger64116472urger
varier94619352varier
verier94620962verier
vier75428152_vier
warier93722892warier
wirer85124952wirer
wirier94215552wirier
wried95518562wried
wries85827742wries
writer94416512writer
wryer11489302wryer

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 Filter178691538000.0931921408.6
2DLD Change Limit538002141.53035163.4
3Display Results2142140.0633396.8
 (SQL Overall)1786912141.686105985.2
 
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.