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

144 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
trike9532016(None) 
strike105619731strike
tike85534491t_ike
tribe74420271tribe
trice75127491trice
trikes105419491trikes
trine54734601trine
tripe75425381tripe
trite54730031trite
troke94821051troke
alike95523962alike
arise56436432arise
bike106532612_bike
brake116025342brake
bribe94820782bribe
bride86425542bride
brie65837902bri_e
brine75132272brine
broke116019782broke
crake114823522crake
crikey15317782crikey
crime94822692crime
cripe95521142cripe
dike95935772_dike
drake104918302drake
drive95318002drive
frise85322452frise
gride75223592gride
grime85021322grime
gripe84622962gripe
hike116830402_hike
kike76524802_kike
like86040852_like
mike105535302_mike
pike106335222_pike
price93725412price
pride84724742pride
prime96525602prime
prise74632612prise
prize164718942prize
rake84841572_rake
rice64942922_rice
ride55945142_ride
rife74632332_rife
rile45650542_rile
rime65138892_rime
ripe66038932_ripe
rise45945242_rise
rite45849462_rite
rive75537732_rive
ryke115616402_ryke
shrike134513242shrike
sike87138792_sike
spike114922842spike
strake104017392strake
striae65422272striae
stride75420962stride
strife95318362strife
striker113714172striker
strikes114719092strikes
stripe85822442stripe
strive95020962strive
stroke105116172stroke
take84739262t_ake
thine85026862thine
thrice114311572thrice
thrive125313222thrive
tide55237392t_ide
tie36557542t_i_e
tikes95628902t_ikes
tiki87620852t_iki
tile45451452t_ile
time66235022t_ime
tine45855142t_ine
tire46143362t_ire
toile54626492toile
toke86738492t_oke
trace75829612trace
trade65026042trade
traik95418202traik_
traiked123310452traiked
traiks104013712traiks
trave85223032trave
tree47745812tr_ee
trek86222312trek_
treks96016852treks
triac74116372triac
triad65217722triad
triage72812892triage
trial54926352trial
tribes85119022tribes
triced95518672triced
tricep103911072tricep
trices84826332trices
trick115420692trick
tricked144016162tricked
tricker134615522tricker
trickie132611032trickie
trickle133613442trickle
tricks125319012tricks
tricky154211472tricky
tried65026912tried
triene64316382triene
trier54328532trier
tries55742812tries
trifle94012882trifle
trig55528162tri_g
trigo65716052trigo
trigs65423062trigs
trijet133916552trijet
trill55122932trill
trim65329522tri_m
trimer85717152trimer
trims75021472trims
trined74920712trined
trines64132562trines
trinket11314812trinket
trio45233342tri_o
triode75311892triode
triol55521362triol
trios55528092trios
triose64715382triose
trip66830392tri_p
tripes85324872tripes
triple84215922triple
trips74923362trips
triste63818642triste
triter65120592triter
triune64210182triune
trivet93721882trivet
trode65322852trode
troika1035492troika
troked114114582troked
trokes104019262trokes
trone55131862trone
trope75725802trope
trove85221922trove
truce75118692truce
true46725852tr_ue
twice104711122twice
twine85822362twine
tyke115720502t_yke
urine55026602urine
write85522832write

Search took 5 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.623286823.4
2DLD Change Limit538001443.45315580.7
3Display Results1441440.0801800.0
 (SQL Overall)1786911444.15642995.9
 
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.