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

263 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
upbows138468(None) 
upbow1245611upbow_
bows96242862__bows
elbows1196712elbows
embows1396822embows
oxbows1833712oxbows
plows105419902_plows
pows95537662_p_ows
prows106327012_prows
sunbows1236022sunbows
umbos94613072umbo_s
upboil1096452upboil
upboils1184702upboils
upbore10247882upbore
updos8389512updo_s
upflows1543512upflows
upgrows1334322upgrows
uptoss836092uptoss
uptown11274962uptown
uptowns12194342uptowns
abbots1039283abbots
abos67734413_abo_s
allows94517683allows
ambos95321253ambo_s
apods86316343ap_ods
apos65433823ap_o_s
aprons8316993aprons
arbors84717883arbors
arrows92813483arrows
avows114910983_avows
baboos103517013baboos
bebops1237623bebops
belows114614183belows
blows105423833_blows
boas66150833__boas
bobs86340653__bobs
bods76244713__bods
bogs75742753__bogs
boos67955033__boos
bops86037983__bops
bos57966813__bo_s
boss65938343__boss
bots66453953__bots
bow87051903__bow_
bowl96827703__bowl
bowls106121433__bowls
bowse105420633__bowse
boys96737333__boys
brows105425983_brows
buboes104513993buboes
bulbous1138293bulbous
burbots1168673burbots
burrows12399093burrows
busboys14325023busboys
cabobs124311893cabobs
cahows14399123cahows
chows135618203_chows
cibols1039523cibols
cows97046643__cows
crows105727313_crows
cuprous1149743cuprous
dhows125911223_dhows
dows85941053__dows
dumbos114111083dumbo_s
ebons74316093_ebons
elbow10117703elbow_
emboss1087383emboss
embow1297563embow_
endows104610423endows
enows85115493_enows
ephods1238363ephods
ephors11311403ephors
epos66723733ep_o_s
flows115822363_flows
fogbows1643853fogbows
frows116623103_frows
furrows13327793furrows
glows95518033_glows
goboes95914443goboes
gobos86219383gobo_s
grows95523923_grows
gumbos114610873gumbo_s
hoboes114717443hoboes
hobos106321353hobo_s
hows106345603__hows
indows104210793indows
jabots1538883jabots
jows146632093__jows
jumbos17379123jumbo_s
jupons15377803jup_ons
kabobs14439303kabobs
kebobs14427293kebobs
knows124912413_knows
kobos115616893kobo_s
kotows13446523kotows
labors84016413labors
lobos75921843lobo_s
lows75843013__lows
lupous849433lup_ous
meows104612683_meows
miaows1145473miaows
mows96340833__mows
nabobs10388213nabobs
nows75738233__nows
oboes75717713_oboes
obols73715863_obols
outrows10311403outrows
oxbow1734443oxbow_
paws96038183_p_aws
peons75327183_peons
pews95731533_p_ews
phons105221143_phons
phots105418503_phots
pions75826393_pions
pious74621273_pious
plews105415353_plews
plods85719293_plods
plops95920333_plops
plots75025673_plots
plow95923233_plow_
ploys105816593_ploys
poboys1397313poboys
pods76540153_p_ods
pois66539043_p_ois
pols66044563_p_ols
poms87037743_p_oms
pons65850603_p_ons
poods85124753_poods
poofs105222793_poofs
poohs103915713_poohs
pools74427703_pools
poons75430973_poons
poops94422413_poops
poos65949113_p_oos
pops86340953_p_ops
pots66452363_p_ots
pow87147283_p_ow_
proas75028803_proas
prods85523553_prods
profs105120893_profs
progs86624153_progs
proms95426413_proms
props95726883_props
pros65742783_pro_s
pross76529403_pross
prow97030383_prow_
prowl105615123_prowl
prowls115511083_prowls
psoas75012983_psoas
pubes94423403pub_es
pubis94616473pub_is
pubs85029213pub__s
putons83515153putons
rebops10311433rebops
replows12329703replows
resows93915353resows
robots8313153robots
rows75941753__rows
sabots8314703sabots
scows106617803_scows
serows96016393serows
shows115324583_shows
slows85323463_slows
snows84719893_snows
sows75342493__sows
spews105015923sp_ews
spoofs114011813spoofs
spooks124312933spooks
spools85115913spools
spoons84116023spoons
spoors84014033spoors
spots74424113sp_ots
stows86622703_stows
strows96718273strows
sunbow1145823sunbow_
syboes1139343syboes
taboos83815433taboos
tabors84517113tabors
throws129715233throws
tows78545553__tows
trows88826183_trows
turbos8910783turbo_s
turbots988023turbots
udons65411463u_dons
udos56619903u_do_s
umbels104510593umbels
umbers104215213umbers
umbles103817493umbles
umbo85516663umbo__
umbones1138013umbones
umbras1038643umbras
unbans81912623unbans
unbars82113033unbars
unbolt83013893unbolt
unbolts9247803unbolts
unborn83310813unborn
unbowed132610243unbowed
unbox1438753unbo_x
unboxes16208303unboxes
uncos74117033unco_s
undoes73917403undoes
unions64216753unions
unmews11326523unmews
unmown11296093unmown
unsews9379363unsews
unsown9328433unsown
upas68322383up__as
upases84112903upases
upbear1096493upbear
upbears1195423upbears
upbeat10911513upbeat
upbeats1195733upbeats
upbind11246313upbind
upbinds12234813upbinds
upborne11255133upborne
upbound12134813upbound
upby1139063upb__y
upbye1244793upb_ye
upcoast1165543upcoast
upcoil10126193upcoil
upcoils1184933upcoils
updo76712883updo__
updove1234483updove
upends9438763upends
upflow1433523upflow_
upfold12124953upfold
upfolds13133753upfolds
upgrow1234273upgrow_
upgrown1343853upgrown
uphold12126903uphold
upholds13135243upholds
uphove1436133uphove
uphroes1236303uphroes
upload9257783upload
uploads10266503uploads
upmost1068193upmost
upo58925863up_o__
upon65817583up_o_n
uppers102912293uppers
upprops1044223upprops
uproar8106933uproar
uproars986453uproars
uproot8314123uproot
uproots937143uproots
uprose82311483uprose
uprouse937223uprouse
ups55629053up___s
upsets8409683upsets
upshots1235193upshots
upsoar8105683upsoar
upsoars985413upsoars
upthrows1643303upthrows
uptore8279453uptore
uptorn8268093uptorn
urbias839093urbias
urbs65922063urb__s
uveous936603uveous
vows106626943__vows
vrows116115263_vrows
widows1376563widows
wows104633493__wows
yows106433123__yows
yupons11398353yup_ons

Search took 7 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 Filter1786911127160.393454684.5
2DLD Change Limit1127162635.62320045.5
3Display Results2632630.0763460.5
 (SQL Overall)1786912636.09229332.1
 
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.