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

228 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
true4672585(None) 
grue55825711grue
rue35549261_rue
tree47745811tree
truce75118691truce
trued65117691trued
truer54916641truer
trues54925321trues
trug55720041trug
ague55725922ague
are37874572ar_e
argue64818442argue
arse46539272arse
arum66129032arum
blue65328462blue
brae65639112brae
bree67241262bree
brie65837902brie
brume95817982brume
brut66537962brut
brute75321782brute
brux136315272brux
clue65324532clue
cru57129562cru_
crud75219612crud
crude86018572crude
cruel74815902cruel
cruet74831842cruet
crus65828482crus
cruse75726102cruse
crux135415002crux
cue57544182_cue
cure66149122cure
dree56638322dree
drub75920132drub
drug65718132drug
drum76521592drum
drupe85012992drupe
druse64817662druse
due45249862_due
dure56341812dure
ere36352772er_e
erne46727422erne
flue75329852flue
frae75330472frae
free75940182free
froe75329992froe
frug86517102frug
glue55628492glue
gree56641562gree
grub77220082grub
gruel66014742gruel
grues65721962grues
grum75625082grum
grume86218162grume
hue66642302_hue
ire36943172ir_e
kue76631862_kue
lure45142462lure
moue65835572moue
mure65941332mure
ore36661832or_e
orle45630462orle
pree67044732pree
prude84615972prude
prune75119632prune
pure65543332pure
re26153742_r_e
ree37974072_ree
roe36861082_roe
roue45941742roue
rub56342822_rub
rube65532012_rube
rude55632782_rude
rued55729792_rued
ruer46127562_ruer
rues46044482_rues
rug46039152_rug
rule49938422_rule
rum56644642_rum
run36244982_run
rune45236292_rune
ruse45938932_ruse
rut35560522_rut
rye66032542_rye
slue45332192slue
sprue74717632sprue
spue66025522spue
strum75619452strum
strut56030732strut
sue35651462_sue
sure45447412sure
tace65342512tace
tae38267052t_ae
take84739262take
tale46154162tale
tame66343662tame
tape64538142tape
tare45957622tare
targe65227092targe
tarre55825632tarre
tate44748602tate
tau36856902tau_
taupe7314162taupe
taus46342732taus
taut47048962taut
tee38366872t_ee
tele45040872tele
terce75721842terce
terne56426152terne
terse55026822terse
thae76825562thae
the67436052t_he
thee78039062thee
three87526912three
throe89321422throe
thru76818942thru_
thrum104713632thrum
thud85613912thud
thug86415482thug
thus76721472thus
tide55237372tide
tie36557532t_ie
tike85534482tike
tile45451442tile
time66235012time
tine45855132tine
tire46143352tire
toe310166852t_oe
togue64816302togue
toke86738492toke
tole46052902tole
tome67543192tome
tone46953742tone
tope65946382tope
toque145113092toque
tore47359322tore
torque15237672torque
torse55833332torse
torte55431702torte
torus54329762torus
tote46643672tote
tour45530382tour
touse55430672touse
tout46753822tout
trace75829612trace
trad55630912trad
trade65026042trade
tram67034552tram
trap67532802trap
trave85223032trave
tray77632592tray
treed65626732treed
treen55622752treen
trees55835762trees
tref77030992tref
trek86222312trek
tres46542902tres
tret46653532tret
trey77228792trey
tribe74420272tribe
trice75127492trice
tried65026912tried
trier54328532trier
tries55742812tries
trig55528162trig
trike95320162trike
trim65329522trim
trine54734602trine
trio45233342trio
trip66830392trip
tripe75425382tripe
trite54730032trite
triune64210182triune
trod57627952trod
trode65322852trode
trog57628212trog
troke94821052troke
trone55131862trone
trop66833302trop
trope75725802trope
trot46351312trot
troupe84812432troupe
trout57332572trout
trove85221922trove
trow78031422trow
troy77429682troy
truced95312052truced
truces84916332truces
truck116115462truck
trudge8318732trudge
truest64816192truest
truffe1276232truffe
trugs65516802trugs
trull54012672trull
truly84111552truly
trump95615122trump
trunk94713042trunk
truss54916922truss
trust55426852trust
truth85214152truth
try66529672tr_y
tub55640032t_ub
tube65828662tube
tug45937402t_ug
tui37034022t_ui
tule45735872tule
tun35845192t_un
tune45635862tune
tup56037542t_up
tuque14469192tuque
turd56027622turd
turf75334052turf
turk86125862turk
turn46330382turn
tut36758092t_ut
tux105426572t_ux
twae74719572twae
twee76827082twee
tye65837442t_ye
tyee75131422tyee
tyke115720502tyke
tyne76325052tyne
type96223742type
tyre75428252tyre
untrue6310772untrue
urge54722412urge
urus46426132urus

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 Filter178691298720.266671770.7
2DLD Change Limit298722280.78038297.4
3Display Results2282280.0464956.5
 (SQL Overall)1786912281.092163636.4
 
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.