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 “upbow” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

272 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
upbow124561(None) 
upbows1384681upbows
bow87051902__bow
elbow10117702elbow
embow1297552embow
oxbow1734442oxbow
plow95923232_plow
pow87147282_p_ow
prow97030382_prow
sunbow1145822sunbow
umbo85516652umbo_
umbos94613062umbos
unbox1438752unbox
upboil1096452upboil
upbore10247882upbore
upby1139062upb_y
upbye1244792upbye
updo76712882updo_
updos8389512updos
upflow1433522upflow
upgrow1234272upgrow
upo58925862up_o_
upon65817582up_on
uptown11274962uptown
abbot9318453abbot
abo59045963_abo_
abos67734413_abos
aglow94711963aglow
allow85420663allow
alow75328593_alow
ambo88225133ambo_
ambos95321243ambos
apo511142123ap_o_
apod78123183ap_od
apos65433823ap_os
apron7318833apron
arbor74818113arbor
arrow83414883arrow
avow107816463_avow
baboo94319503baboo
bebop11410793bebop
below104617193below
blow95827193_blow
bo410957573__bo_
boa56954033__boa
bob76755663__bob
bod67055543__bod
bog67852413__bog
boo58163663__boo
bop77549483__bop
bos57966813__bos
bot59680403__bot
bowl96827703__bowl
bows96242863__bows
box1210142343__box
boy87753563__boy
brow97228443_brow
bubo85621903bubo_
burbot10815653burbot
burrow114610803burrow
busboy13307443busboy
cabob114616803cabob
cahow135110943cahow
chow125820993_chow
cibol9512023cibol
cow89856713__cow
crow96428133_crow
dhow116614003_dhow
dow76749973__dow
dumbo105614063dumbo_
dumbos114111083dumbos
ebon66821103_ebon
elbows1196713elbows
embows1396813embows
endow94510983endow
enow77819873_enow
ephod1139123ephod
ephor10310013ephor
epos66723733ep_os
flow105924923_flow
fogbow1544783fogbow
frow106425053_frow
furrow12427743furrow
glow85222523_glow
gobo76126893gobo_
gobos86219373gobos
grow86127303_grow
gumbo104413583gumbo_
gumbos114610873gumbos
hobo97026083hobo_
hobos106321353hobos
how97252433__how
indow95011663indow
jabot14321513jabot
jow137639303__jow
jumbo164311073jumbo_
jumbos17379123jumbos
jupon14479193jup_on
kabob134113923kabob
kebob135110913kebob
know116115843_know
kobo107422103kobo_
kobos115616893kobos
kotow12528703kotow
labor75117313labor
lobo67229863lobo_
lobos75921843lobos
low66051873__low
meow95117883_meow
miaow1058353miaow
mow86650353__mow
nabob93913733nabob
nohow1137293nohow
now65950193__now
oboe66822943_oboe
obol65220613_obol
outbox1537453outbox
outrow9311173outrow
ow58950173___ow
oxbows1833713oxbows
paw87651173_p_aw
peon65635243_peon
pew86442303_p_ew
phew128417113_phew
phon95925383_phon
phot95534353_phot
pion67235293_pion
plew97222813_plew
plod76723273_plod
plop86625743_plop
plot66141233_plot
plows105419903_plows
ploy96123603_ploy
poboy121612223poboy
pod66351483_p_od
poh86740533_p_oh
poi57244663_p_oi
pol56449383_p_ol
pom78249913_p_om
poo57757113_p_oo
pood75934323_pood
poof95541663_poof
pooh96027383_pooh
pool65835953_pool
poon67341263_poon
poop86532813_poop
poor65630223_poor
poos65949113_poos
pop76252253_p_op
pot58078433_p_ot
pows95537663_p_ows
pox126140693_p_ox
pro55837263_pro_
proa66229963_proa
prod76129503_prod
prof96134663_prof
prog75729003_prog
prom87631693_prom
prop85932813_prop
pros65742783_pros
prowl105615123_prowl
prows106327013_prows
pub76037693pub__
pubes94423403pubes
pubic114513713pubic
pubis94616463pubis
pubs85029213pub_s
puton73617913puton
rebop9313283rebop
replow114210343replow
resow88217243resow
robot7325973robot
row67453673__row
sabot7931773sabot
scow96021423_scow
serow86720443serow
show106229183_show
slow77729493_slow
snow76324793_snow
sow66554763__sow
spew95421873sp_ew
spoof105019013spoof
spook115416043spook
spool75219043spool
spoon74719443spoon
spoor75016353spoor
spot65540683sp_ot
stow77325743_stow
strow88920573strow
sunbows1236023sunbows
sybo9714743sybo_
taboo73418093taboo
tabor75518393tabor
throw118719733throw
tow610557363__tow
trow78031423_trow
turbo71015043turbo_
turbos8910783turbos
turbot8914263turbot
udo49027303u_do_
udon56017743u_don
udos56619903u_dos
umbel93612833umbel
umber94617583umber
umbra948503umbra
unban72114333unban
unbar71913613unbar
unbe65319273unb_e
unbid83214633unbid
unbolt83013893unbolt
unborn83310813unborn
unbowed132610243unbowed
unco66021403unco_
uncos74117033uncos
uncoy104111413uncoy
undo55620153undo_
ungot61718063ungot
union54519793union
unmew103610073unmew
unmown11296093unmown
unsew83912693unsew
unsown9328433unsown
unto45824283unto_
unwon84512343unwon
up47832823up___
upas68322383up_as
upbear1096493upbear
upbeat10911513upbeat
upbind11246303upbind
upboils1184703upboils
upborne11255133upborne
upbound12134813upbound
upcoil10126193upcoil
updove1234483updove
updry1135483updry
upend85011043upend
upflows1543513upflows
upfold12124953upfold
upgrew1233653upgrew
upgrown1343853upgrown
upgrows1334323upgrows
uphold12126903uphold
uphove1436133uphove
uphroe1136083uphroe
uplit76020803uplit
upload9257783upload
upmost1068193upmost
upped103715163upped
upper93714263upper
upprop944093upprop
uproar8106933uproar
uproot8314123uproot
uprose82311483uprose
ups55629053up__s
upset73222593upset
upshot1138453upshot
upsoar8105683upsoar
upthrow1543193upthrow
uptore8279453uptore
uptorn8268093uptorn
uptoss836093uptoss
uptowns12194343uptowns
urb55731103urb__
urban72013863urban
urbia7311133urbia
urbs65922053urb_s
vow96136313__vow
vrow105817473_vrow
widow1278933widow
wow96643473__wow
yow96945293__yow
yupon10469483yup_on

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 Filter178691836670.1261418182.5
2DLD Change Limit836672724.46618734.2
3Display Results2722720.1431902.1
 (SQL Overall)1786912724.73537738.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.