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

356 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
wart7786608(None) 
art38679141_art
cart66570341cart
dart55857871dart
fart76860561fart
hart76865771hart
kart86750801kart
mart66865971mart
part65967461part
swart86234641swart
tart47566181tart
waft106139001waft
wait75553691wait
want76156161want
war67262421war_
ward86542251ward
ware76254721ware
wark115737771wark
warm95935671warm
warn75239321warn
warp95635001warp
wars78659801wars
warts814840401warts
warty119323821warty
wary106740011wary
wast75655851wast
wat67378921wa_t
watt75545411watt
wert79749821wert
wort76654751wort
act59557842_act
aft66849012_aft
airt45757782airt
ait38093902_ait
alt36467962_alt
ant37270782_ant
apart74330672apart
apt57352542_apt
ar211379382_ar_
arb510448422_arb
arc510250902_arc
are37874572_are
arf67453372_arf
ark77044962_ark
arm58449622_arm
ars37670932_ars
arts49650262_arts
arty77531312_arty
at212393402_a_t
att35454652_att
await85524492await
award97118042award
aware86420022aware
awry107619682awry
baht96740012baht
bait66556002bait
bar58070552bar_
barb85240062barb
bard75648862bard
bare65460522bare
barf95844412barf
bark106242152bark
barm86739602barm
barn66444642barn
bars66564092bars
bast66362412bast
bat510988952ba_t
batt65053872batt
boart78835932boart
bort65960962bort
brat66055542brat
cant66362022cant
car59165562car_
carat75048792carat
carb85143162carb
card710245872card
care66968372care
caret75360562caret
cark105539272cark
carl65144782carl
carn66245432carn
carp85139812carp
carr65434702carr
cars67364762cars
carte75940422carte
carts78946292carts
cast67159902cast
cat58282342ca_t
chart105038282chart
curt67051712curt
daft85537252daft
darb76033532darb
dare55848862dare
dark95133212dark
darn56434622darn
darts67635732darts
daut56443562daut
dawt85435942dawt
dirt55550382dirt
drat56247832drat
dwarf126015242dwarf
ear36867882ear_
earl45838142earl
earn46737552earn
ears46356592ears
earth85023052earth
east46659102east
eat36989052ea_t
fact97142542fact
far67762602far_
fard85639062fard
fare76354462fare
farl76338552farl
farm95934532farm
faro76136922faro
farts88336842farts
fast77052312fast
fat68178082fa_t
fort76456442fort
frat75648542frat
gait56150192gait
gar47259902gar_
garb75332672garb
gars55750742gars
garth94720222garth
gast56052562gast
gat46880512ga_t
girt56646422girt
grat55651282grat
haet75659502haet
haft105941842haft
halt76056302halt
hant75461582hant
hard85443502hard
hare76255732hare
hark115237392hark
harl75740002harl
harm95637792harm
harp96134282harp
harts88441592harts
hast76259482hast
hat67289962ha_t
haut75949732haut
heart85440742heart
hurt77142572hurt
jar107646152jar_
jarl115828132jarl
jars117338352jars
karat96837592karat
karn86129412karn
karst97228992karst
karts97630112karts
kat77468292ka_t
lar37967532lar_
lard56742002lard
lari45839152lari
lark85733862lark
lars46956572lars
last46260322last
lat37593402la_t
lyart85121882lyart
malt66254802malt
mar57965942mar_
mara67444562mara
marc87034622marc
mare64759322mare
mark105138052mark
marl66341612marl
mars66261862mars
marts77442232marts
mast65959952mast
mat58083932ma_t
matt65752652matt
maut65448442maut
mort66758832mort
narc67127952narc
nard56634452nard
nark85230062nark
nary76931222nary
oar37057952oar_
oars46846032oars
oast47156322oast
oat39888262oa_t
ort39465232_ort
pact86648722pact
pant66061252pant
par57467022par_
para65242172para
pard76441322pard
pare66760842pare
park105237492park
parr65731152parr
pars67560792pars
parts77743372parts
party106630612party
past65959012past
pat58089462pa_t
peart76440752peart
pert66759322pert
port66059632port
prat65952042prat
qat125253332qa_t
quart144027852quart
raft76245912raft
rant45864672rant
rapt67245312rapt
rare45348432rare
rat37892742ra_t
salt45758522salt
sard55344242sard
sari45444042sari
sark84938972sark
sat36288482sa_t
scart76139772scart
smart75834092smart
sort46264812sort
start55642312start
sward94221462sward
sware85828212sware
swarf115324652swarf
swarm106218832swarm
swarth126012082swarth
swarty125812382swarty
swat77244442swa_t
tact67349032tact
tar37570692tar_
tare45957622tare
tarn46842722tarn
taro46846912taro
tarot55943932tarot
tarp66936412tarp
tars46763952tars
tarts57242022tarts
tarty86328182tarty
tat37690292ta_t
taut47048962taut
thwart12311682thwart
tort46967462tort
twat75831512twa_t
var66148332var_
vara75530882vara
vars75742072vars
vary105226062vary
vast75045122vast
vat67863452va_t
vert77249372vert
wab87051832wa_b
wabs97337232wabs
wack135330912wack
wad77053892wa_d
wade85237062wade
wadi86228172wadi
wads87343142wads
wady115324992wady
wae67556952wa_e
waes76048602waes
waff134228042waff
wafts116920552wafts
wag76451752wa_g
wage84834082wage
wags86140552wags
waif105836752waif
wail75238822wail
wain75840192wain
wair75830052wair
wairs86424062wairs
waist86132382waist
waits88333522waits
wake114935702wake
wale74546432wale
walk115625612walk
wall76236102wall
waltz17615472waltz
waly105830902waly
wame95035482wame
wan66761932wa_n
wand85833872wand
wane76344712wane
wank115632502wank
wans76452262wans
wants87932212wants
wany106432352wany
wap86553372wa_p
waps96642082waps
wards97734402wards
wared96339872wared
wares88250582wares
warks127932402warks
warms107726852warms
warmth1477932warmth
warns87231002warns
warps107126422warps
warted104223232warted
was68767562wa_s
wash106033812wash
wasp95626852wasp
waste86125052waste
wasts87433672wasts
wats77555882wats
watts86923092watts
wauk115220592wauk
waul76927312waul
waur76819902waur
wave105234732wave
wavy136620472wavy
waw97046382wa_w
wawl105321942wawl
waws106834902waws
wax137041182wa_x
waxy175918202waxy
way96757662wa_y
ways107737952ways
wear75836722wear_
wears86030302wears
weary115620612weary
weet75254152weet
weft105435012weft
welt75547862welt
went76051872went
wept95635052wept
were76238332were
west75748082west
wet65966622w_et
wharf14315822wharf
what105434072what
whet105133782whet
whit104834172whit
whort114623692whort
wilt76246292wilt
wire75839812wire
wiry106422832wiry
wist78049292wist
wit66563772w_it
wont75842502wont
word89832002word
wore77144672wore
work115528842work
worm96129482worm
worn75631752worn
worst86330132worst
worth117120522worth
worts88631182worts
wost76544362wost
wot610467482w_ot
wrap96821972wrap
wrapt105123182wrapt
wrath115715872wrath
writ75537912writ
wry96524702w_ry
wurst85122992wurst
yar67253832yar_
yard85633252yard
yare75636942yare
yarn75230042yarn
yurt76435042yurt
zarf166929122zarf

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.0802233637.5
2DLD Change Limit298723560.93631914.5
3Display Results3563560.0804450.0
 (SQL Overall)1786913561.096163039.2
 
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.