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

176 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
tripe7542538(None) 
cripe95521141cripe
gripe84622961gripe
ripe66038921_ripe
stripe85822441stripe
tribe74420271tribe
trice75127491trice
trike95320161trike
trine54734601trine
trip66830391trip_
tripes85324871tripes
triple84215921triple
trips74923361trips
trite54730031trite
trope75725801trope
arise56436432arise
atrip75315752atrip_
bribe94820782bribe
bride86425532bride
brie65837902bri_e
brine75132272brine
crape96128442crape
crepe95520722crepe
crime94822692crime
cripes105120872cripes
drape85319632drape
drip76223952drip_
drips85417232drips
dript86923872dript
drive95318002drive
drupe85012992drupe
frise85322452frise
grape84824662grape
gride75223582gride
grime85021322grime
grip76127022grip_
griped104114712griped
griper94114612griper
gripes94619872gripes
gripey124111202gripey
grippe115310322grippe
grips85520132grips
gript85126172gript
gripy115115252gripy
grope84821612grope
lipe66839732_lipe
pipe86434432_pipe
price93725412price
pride84724732pride
prime96525602prime
prise74632612prise
prize164718942prize
rape65041632_rape
rice64942912_rice
ride55945122_ride
rife74632322_rife
rile45650532_rile
rime65138882_rime
rip56851302_rip_
riped85226432_riped
ripen75619262_ripen
riper74328402_riper
ripes75435772_ripes
rips66237432_rips
rise45945232_rise
rite45849452_rite
rive75537722_rive
rope65542912_rope
sipe67341042_sipe
slipe75626132slipe
snipe75320572snipe
stipe76523372stipe
striae65422272striae
stride75420962stride
strife95318362strife
strike105619732strike
strip77524342strip_
striped105214362striped
striper94514792striper
stripes95320572stripes
strips85719652strips
stript85222192stript
stripy115812742stripy
strive95020962strive
swipe105217082swipe
tape64538142t_ape
taupe7314162taupe
thine85026862thine
thrice114311572thrice
thrip103012182thrip_
thrips11299012thrips
thrive125313222thrive
tide55237372t_ide
tie36557532t_i_e
tike85534482t_ike
tile45451442t_ile
time66235012t_ime
tine45855132t_ine
tip56551222t_ip_
tipi69924432t_ipi
tips66436762t_ips
tire46143352t_ire
toile54626492toile
tope65946382t_ope
trace75829612trace
trade65026042trade
traipse935872traipse
trap67532802trap_
trapes85024462trapes
traps75727482traps
trapt76433392trapt
trave85223032trave
tree47745812tr_ee
triac74116372triac
triad65217722triad
triage72812892triage
trial54926352trial
tribes85119022tribes
triced95518672triced
tricep103911072tricep
trices84826332trices
trick115420692trick
tried65026912tried
triene64316382triene
trier54328532trier
tries55742812tries
trifle94012882trifle
trig55528162tri_g
trigo65716052trigo
trigs65423062trigs
trijet133916552trijet
trikes105419492trikes
trill55122932trill
trim65329522tri_m
trimer85717152trimer
trims75021472trims
trined74920712trined
trines64132562trines
trio45233342tri_o
triode75311892triode
triol55521362triol
trios55528092trios
triose64715382triose
tripled104113832tripled
triples94616872triples
triplet94319212triplet
triplex16447802triplex
triply114211022triply
tripod9399852tripod
tripos84014922tripos
tripped123911692tripped
tripper113711922tripper
trippet113714112trippet
trippy13457802trippy
triste63818642triste
triter65120592triter
triune64210182triune
trivet93721882trivet
trode65322852trode
troke94821052troke
trompe105611262trompe
trone55131862trone
trop66833302trop_
tropes84824352tropes
troupe84812432troupe
trove85221922trove
truce75118692truce
true46725852tr_ue
twice104711122twice
twine85822362twine
type96223742t_ype
unripe82012092unripe
urine55026592urine
wipe94830282_wipe
write85522832write
yipe96722182_yipe

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 Limit538001761.76630464.3
3Display Results1761760.0463826.1
 (SQL Overall)1786911761.90593801.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.