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

171 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
trice7512749(None) 
price93725411price
rice64942911_rice
thrice114311571thrice
trace75829611trace
tribe74420271tribe
triced95518671triced
tricep103911071tricep
trices84826331trices
trick115420691trick
trike95320161trike
trine54734601trine
tripe75425381tripe
trite54730031trite
truce75118691truce
twice104711121twice
amice96122872amice
arise56436432arise
bice86235562_bice
brace95629272brace
bribe94820782bribe
brick134618152brick
bride86425532bride
brie65837902bri_e
brine75132272brine
crick135118752crick
crime94822692crime
cripe95521142cripe
deice84320032deice
dice75841892_dice
drive95318002drive
erica7316542erica
fice95737112_fice
frise85322452frise
grace85124542grace
gride75223582gride
grime85021322grime
gripe84622962gripe
ice56737242__ice
juice14311322juice
lice66045062_lice
mice87442232_mice
nice65534712_nice
orrice81410162orrice
pice84641092_pice
priced115018882priced
pricer103918292pricer
prices104524542prices
pricey134412632pricey
prick134317502prick
pricy124814562pricy
pride84724732pride
prime96525602prime
prince104114762prince
prise74632612prise
prize164718942prize
race66746262_race
riced85825542_riced
ricer74726612_ricer
rices75536152_rices
rich97025542_rich
rick107334652_rick
ride55945122_ride
rife74632322_rife
rile45650532_rile
rime65138882_rime
ripe66038922_ripe
rise45945232_rise
rite45849452_rite
rive75537722_rive
saice75424052saice
sice65545592_sice
slice74925822slice
spice95528812spice
striae65422272striae
strick124813202strick
strict84821042strict
stride75420962stride
strife95318362strife
strike105619732strike
stripe85822442stripe
strive95020962strive
tace65342512t_ace
terce75721842terce
thick145613352thick
thine85026862thine
thrive125313222thrive
tic56343462t_ic_
tick106231222t_ick
tics65729632t_ics
tide55237372t_ide
tie36557532t_i_e
tike85534482t_ike
tile45451442t_ile
time66235012t_ime
tine45855132t_ine
tire46143352t_ire
toile54626492toile
toric76529312toric_
torics85118352torics
traced94821582traced
tracer84820232tracer
traces85329932traces
track114823012track
tract75635712tract
trade65026042trade
trance84718762trance
trave85223032trave
tree47745812tr_ee
triac74116372triac
triacs83913222triacs
triad65217722triad
triage72812892triage
trial54926352trial
tribes85119022tribes
triceps11267342triceps
tricked144016162tricked
tricker134615522tricker
trickie132611032trickie
trickle133613442trickle
tricks125319012tricks
tricky154211472tricky
tricot8317752tricot
tried65026912tried
triene64316382triene
trier54328532trier
tries55742812tries
trifle94012882trifle
trig55528162tri_g
trigo65716052trigo
trigs65423062trigs
trijet133916552trijet
trikes105419492trikes
trill55122932trill
trim65329522tri_m
trimer85717152trimer
trims75021472trims
trined74920712trined
trines64132562trines
trio45233342tri_o
triode75311892triode
triol55521362triol
trios55528092trios
triose64715382triose
trip66830392tri_p
tripes85324872tripes
triple84215922triple
trips74923362trips
triste63818642triste
triter65120592triter
triune64210182triune
trivet93721882trivet
troche113112512troche
trock114817602trock
trode65322852trode
troke94821052troke
trone55131862trone
trope75725802trope
trove85221922trove
truced95312052truced
truces84916332truces
truck116115462truck
true46725852tr_ue
twine85822362twine
uric63624932uric_
urine55026592urine
utricle937912utricle
vice95732852_vice
voice104915322voice
wrick144013392wrick
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.0931921408.6
2DLD Change Limit538001711.48636204.6
3Display Results1711710.0463717.4
 (SQL Overall)1786911711.625109963.7
 
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.