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

134 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
tribe7442027(None) 
bribe94820781bribe
tribes85119021tribes
trice75127491trice
trike95320161trike
trine54734601trine
tripe75425381tripe
trite54730031trite
arise56436432arise
bribed115312842bribed
bribee104316362bribee
briber104714052briber
bribes105918532bribes
bride86425542bride
brie65837902bri_e
brine75132272brine
caribe103416752caribe
crib86323582crib_
cribs94516752cribs
crime94822692crime
cripe95521142cripe
drib76823262drib_
dribs85115062dribs
drive95318002drive
frise85322452frise
gibe75927792_gibe
grebe85114942grebe
gride75223592gride
grime85021322grime
gripe84622962gripe
jibe136323402_jibe
kibe106523462_kibe
oribi7311092oribi
price93725412price
pride84724742pride
prime96525602prime
prise74632612prise
prize164718942prize
probe94320812probe
rib56848042_rib_
ribes75530172_ribes
ribs65833032_ribs
rice64942922_rice
ride55945142_ride
rife74632332_rife
rile45650542_rile
rime65138892_rime
ripe66038932_ripe
rise45945242_rise
rite45849462_rite
rive75537732_rive
robe65335642_robe
rube65532012_rube
scribe104613532scribe
striae65422272striae
stride75420962stride
strife95318362strife
strike105619732strike
stripe85822442stripe
strive95020962strive
strobe84513812strobe
thebe107515432thebe
thine85026862thine
thrice114311572thrice
thrive125313222thrive
tide55237392t_ide
tie36557542t_i_e
tike85534492t_ike
tile45451452t_ile
time66235022t_ime
tine45855142t_ine
tire46143362t_ire
toile54626492toile
trace75829612trace
trade65026042trade
trave85223032trave
treble8311662treble
tree47745812tr_ee
triable92515392triable
triac74116372triac
triad65217722triad
triage72812892triage
trial54926352trial
tribade1037292tribade
tribal8611132tribal
tribune945572tribune
tribute937312tribute
triced95518672triced
tricep103911072tricep
trices84826332trices
trick115420692trick
tried65026912tried
triene64316382triene
trier54328532trier
tries55742812tries
trifle94012882trifle
trig55528162tri_g
trigo65716052trigo
trigs65423062trigs
trijet133916552trijet
trikes105419492trikes
trilby1144972trilby
trill55122932trill
trim65329522tri_m
trimer85717152trimer
trims75021472trims
trined74920712trined
trines64132562trines
trio45233342tri_o
triode75311892triode
triol55521362triol
trios55528092trios
triose64715382triose
trip66830392tri_p
tripes85324872tripes
triple84215922triple
trips74923362trips
triste63818642triste
triter65120592triter
triune64210182triune
trivet93721882trivet
trode65322852trode
troke94821052troke
trone55131862trone
trope75725802trope
trove85221922trove
truce75118692truce
true46725852tr_ue
tube65828662t_ube
twice104711122twice
twine85822362twine
urine55026602urine
vibe95124512_vibe
write85522832write

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.296603685.8
2DLD Change Limit538001341.44037361.1
3Display Results1341340.0462913.0
 (SQL Overall)1786911341.782100275.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.