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

260 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
trad5563091(None) 
brad75234341brad
grad66829861grad
orad56031691orad
rad47662001_rad
tad47959821t_ad
toad55830181toad
trade65026041trade
tram67034551tram
trap67532801trap
tray77632591tray
tread64821701tread
triad65217721triad
trod57627951trod
ad311975032__ad
arak86929572arak
arid57642712arid
bad67763152_bad
bard75648862bard
bead75937922bead
bra56339462bra_
brads85528292brads
brae65639112brae
brag75229722brag
braid85822262braid
bran65740382bran
brand85124492brand
bras65746452bras
brat66055542brat
braw94829562braw
bray95232902bray
bread85523112bread
bred75130972bred
broad84817692broad
cad67456362_cad
card710245872card
chad105525502chad
clad76225822clad
crab85727672crab
crag75625302crag
cram85635492cram
crap85731842crap
craw97725262craw
cred76530882cred
crud75219612crud
dad58456162_dad
dead65434242dead
drab76226452drab
drag64825052drag
dram75832002dram
drat56247832drat
draw85623012draw
dray85428092dray
dread74419022dread
dryad10477582dryad
duad66521412duad
dyad96415452dyad
egad64215412egad
era35741502era_
eras45441502eras
fad77452412_fad
farad95720672farad
fard85639062fard
frae75330472frae
frag85126272frag
frap95925812frap
frat75648542frat
fraud939862fraud
fray105428902fray
gad57556652_gad
glad65624012glad
goad66830982goad
grab75427612grab
grade75126092grade
grads75625752grads
gram77034582gram
gran56335012gran
grand75122692grand
grat55651282grat
gray85329892gray
grid65829612grid
had77658762_had
hard85443502hard
head87137172head
irade65618152irade
ired55131872ired
irid55927162irid
lad48165702_lad
lard56742002lard
lead56038852lead
load56730602load
mad68958702_mad
mead75531602mead
nard56634452nard
ora37250832ora_
oral47638122oral
oread64619602oread
pad68057322_pad
pard76441322pard
pram85733492pram
prao66229022prao
prat65952042prat
prau66529472prau
pray96331532pray
prod76129502prod
quad144618702quad
rads56046602_rads
rag45761322_rag
rah68052402_rah
rai37658222_rai
raid55243072_raid
raj105740222_raj
ram56867272_ram
ran38266612_ran
rand55839562_rand
rap56261962_rap
ras37575392_ras
rat37892742_rat
raw67252252_raw
rax108445722_rax
ray66361992_ray
read55942532read
red46755802_red
rid46754622_rid
road56332112road
rod47953892_rod
sad47459202_sad
sard55344242sard
scad75725762scad
shad86230912shad
stead65520272stead
strand74514822strand
strap77925262strap
straw813321292straw
stray88525572stray
ta211662452t_a_
tab57460322t_ab
tads57143942t_ads
tae38267052t_ae
tag47259492t_ag
taj106442192t_aj
tam58663422t_am
tan37167562t_an
tao38358952t_ao
tap57663872t_ap
tar37570692t_ar
tardo65321102tardo
tardy94720462tardy
tare45957622tare
tared69340052tared
tarn46842722tarn
taro46846912taro
tarp66936412tarp
tars46763952tars
tart47566182tart
tas38477102t_as
tat37690292t_at
tau36856902t_au
tav66043212t_av
taw610155452t_aw
tax109449152t_ax
tea37353322tea_
teak85930842teak
teal45546502teal
team66238652team
tear45242882tear
teas45851492teas
teat45963632teat
ted46446562t_ed
teed55439262teed
tend56433772tend
terai53525482terai
tetrad73612052tetrad
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
thraw1110515922thraw
thread105011092thread
thud85613912thud
tied55535212tied
tirade7311692tirade
tired65228902tired
toads65621062toads
toady96814342toady
tod49457072t_od
toed56137042toed
told56132202told
tora47545992tora_
torah87125272torah
toras55540372toras
trace75829612trace
traced94821582traced
track114823012track
tract75635712tract
traded85717682traded
trader75218752trader
trades75724492trades
tragi64717172tragi
traik95418202traik
trail55126772trail
train56529112train
trait56940842trait
tramp96319772tramp
trams75327672trams
trank96222422trank
tranq145416892tranq
trans54933042trans
traps75727482traps
trapt76433392trapt
trash86119762trash
trass56226472trass
trave85223032trave
trawl84915872trawl
trays85623432trays
treads74817912treads
treat56240352treat
tree47745812tree
treed65626732treed
tref77030992tref
trek86222312trek
trend64817452trend
tres46542902tres
tret46653532tret
trey77228792trey
triac74116372triac
triads74513522triads
trial54926352trial
tried65026912tried
trig55528162trig
trim65329512trim
trio45233342trio
trip66830392trip
troak95213572troak
trode65322852trode
trog57628212trog
trop66833302trop
trot46351312trot
trow78031422trow
troy77429682troy
true46725852true
trued65117692trued
trug55720042trug
try66529672tr_y
tsade64311122tsade
tsadi6379912tsadi
tsar47819802tsar
turd56027622turd
twa67721642twa_
twae74719572twae
twas76824082twas
twat75831512twat
tyred95816432tyred
tzar136315372tzar
urd46427042ur_d
wad77053892_wad
ward86542252ward
woad85523942woad
wrap96821972wrap
yard85633252yard

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.0762351197.4
2DLD Change Limit298722601.23624168.3
3Display Results2602600.1232113.8
 (SQL Overall)1786912601.435124523.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.