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

205 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
trite5473003(None) 
rite45849451_rite
tribe74420271tribe
trice75127491trice
trike95320161trike
trine54734601trine
tripe75425381tripe
triste63818641triste
triter65120591triter
write85522831write
arete56031352arete
arise56436432arise
attrite7311832attrite
axite125218252axite
barite84224812barite
bite66547002_bite
blite76225352blite
boite74426322boite
bribe94820782bribe
bride86425532bride
brie65837902bri_e
brine75132272brine
brit66350152brit_
brith104924372brith
brits76433082brits
britt75732232britt
brute75321782brute
cerite84724872cerite
cite65640342_cite
crate76537402crate
crime94822692crime
cripe95521142cripe
crit65743712crit_
crits75527572crits
curite85222942curite
dite55547552_dite
drive95318002drive
elite56230182elite
evite85317682evite
flite85424962flite
frise85322452frise
frit77044472frit_
frites94922482frites
frith115922032frith
frits86129102frits
fritt86129412fritt
fritz176020772fritz
gite55438612_gite
grate64932882grate
gride75223582gride
grime85021322grime
gripe84622962gripe
grit55247242grit_
grith95520372grith
grits65529582grits
irate55627982irate
kite85338232_kite
lite47054542_lite
mite66249412_mite
nite45943582_nite
nitrite72314462nitrite
norite63221132norite
orate55133302orate
prate75135982prate
price93725412price
pride84724732pride
prime96525602prime
prise74632612prise
prize164718942prize
pyrite11913312pyrite
quite144621462quite
rate45458762_rate
rete44944132_rete
rice64942912_rice
ride55945122_ride
rife74632322_rife
rile45650532_rile
rime65138882_rime
ripe66038922_ripe
rise45945232_rise
rites54442552_rites
ritz135129982_ritz
rive75537722_rive
rote46249022_rote
site47052412_site
skite95120042skite
smite75224872smite
spite75430662spite
sprite84421772sprite
striae65422272striae
striate74218952striate
stride75420962stride
strife95318362strife
strike105619732strike
stripe85822442stripe
strive95020962strive
suite54829562suite
taste55127232taste
tate44748602t_ate
taxite13511302taxite
terete6319332terete
tergite8311002tergite
termite9313892termite
thine85026852thine
thorite10313442thorite
thrice114311572thrice
thrive125313222thrive
tide55237372t_ide
tie36557532t_i_e
tike85534482t_ike
tile45451442t_ile
time66235012t_ime
tine45855132t_ine
tire46143352t_ire
tit36771042t_it_
titer55430612t_iter
tithe85319702t_ithe
titi47130612t_iti
title54721072t_itle
titre54619392t_itre
tits46145032t_its
toile54626492toile
toit46353062toit_
toited74016752toited
toits55327472toits
torte55431702torte
tote46643672t_ote
trace75829612trace
trade65026042trade
trait56940842trait_
traits65121982traits
trave85223032trave
tree47745812tr_ee
tret46653532tret_
trets55928022trets
triac74116372triac
triad65217722triad
triage72812892triage
trial54926352trial
tribes85119022tribes
tribute937312tribute
triced95518672triced
tricep103911072tricep
trices84826332trices
trick115420692trick
tried65026912tried
triene64316382triene
trier54328532trier
tries55742812tries
trifle94012882trifle
trig55528162tri_g
trigo65716052trigo
trigs65423062trigs
trijet133916552trijet
trikes105419492trikes
trill55122932trill
trim65329512tri_m
trimer85717152trimer
trims75021472trims
trined74920712trined
trines64132562trines
trio45233342tri_o
triode75311892triode
triol55521362triol
trios55528092trios
triose64715382triose
trip66830392tri_p
tripes85324872tripes
triple84215922triple
trips74923362trips
tritely1039002tritely
tritest7315272tritest
triton63914892triton
tritone73613882tritone
triune64210182triune
trivet93721882trivet
trode65322852trode
troke94821052troke
trone55131862trone
trope75725802trope
trot46351312trot_
troth85622202troth
trots56629942trots
trove85221922trove
truce75118692truce
true46725852tr_ue
truth85214152truth
tryste9399582tryste
turgite837972turgite
twice104711122twice
twine85822362twine
twit76329062twit_
twits86015792twits
unite54828382unite
urate55432162urate
urine55026592urine
verite94323442verite
white114920302white
wite75443272_wite
writ75537912writ_
writer94416512writer
writes94420332writes
writhe125310702writhe
writs86624382writs
wrote84717482wrote

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 Limit538002051.65632487.9
3Display Results2052050.0633254.0
 (SQL Overall)1786912051.81298615.3
 
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.