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

113 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
bugshas133451(None) 
bugsha1233821bugsha_
buqshas2143571buqshas
buddhas1463262buddhas
buqsha2032792buqsha_
bursas85318272burs_as
bushes115226112bu_shes
bushwas15105612bu_shwas
aghas97014873_ag_has
aughts104710243aug_hts
balsas86417523bals_as
bashaw14349303b_ashaw
bashaws15347713b_ashaws
bashes115631393b_ashes
berthas12398763berthas
bights124417963big_hts
blushes124314823blushes
borshts1266543borshts
boshes114721883b_oshes
boughs125414373boug_h_s
brashes124518463brashes
brughs12509063brug_h_s
brushes124014663brushes
bubbas94110703bu_bbas
buckras1537343buckras
buddha1333173buddha_
bugbear1233953bugbear
bugbears1333693bugbears
bugeyes1335513bugeyes
buggers114315663buggers
buggies114613813buggies
buglers105115323buglers
bugles94822443bug_les
bugloss1035893bugloss
bugouts1036193bugouts
bugs76035913bug___s
bugseed1136173bugseed
bugseeds1242843bugseeds
buhls105111803bu__hls
buhrs104811243bu__hrs
bullshat1344973bullshat
bumphs15467103bumph_s
bunas75126573bu__nas
bunches144116033bunches
bunyas11359433bu_nyas
buras74736293bu__ras
burghal1335073burghal
burghs12519923burgh_s
burkas124513803bu_rkas
burqas174410903bu_rqas
bursa74921523burs_a_
bursae84515603burs_ae
bursal84414823burs_al
bursar85413253burs_ar
bursars94510893bursars
burses84425513burs_es
bursts85116243burs_ts
busbar1038453bu_sbar
busbars1138153bu_sbars
buses75936013bu_s_es
bush96630713bu_sh__
bushed124822383bu_shed
bushel114513943bu_shel
bushels124110713bu_shels
busher114922203bu_sher
bushers124018803bu_shers
bushman1455693bu_shman
bushwa14105143bu_shwa
bushwah18123983bu_shwah
bushwahs19113333bu_shwahs
bushy135416683bu_sh_y
busies85525263bu_sies
busks115521373bu_s_ks
busman10310253bu_sman
buss65134913bu_s__s
busses85023383bu_sses
busts75227693bu_s_ts
butches144315363butches
cuestas957933cuestas
cuishes122810823cuishes
cumshaw1742303cumshaw
cumshaws1842223cumshaws
cushat113513693cu_shat
cushats12288273cu_shats
cushaw14386983cu_shaw
cushaws15356293cu_shaws
geishas1135063geishas
gurshes112210033gurshes
gushes104719033gu_shes
hushes124718593hu_shes
kashas133311903_kashas
lushes94022743lu_shes
mughal1236263mug_hal
mughals1355753mug_hals
murrhas12286163murrhas
mushes114124563mu_shes
orishas1036473orishas
oughts104710183oug_hts
pashas115117063_pashas
pushes114621663pu_shes
quashes192110973quashes
qurshes19228573qurshes
rugolas836373rugolas
rugosas844973rugosas
rushes94724363ru_shes
sughs95313323sug_h_s
sulphas1236243sulphas
sushis9311183su_shis
tushes94319473tu_shes
tussahs10335113tussahs
ughs85410973_ug_h_s
vughs12678743vug_h_s
yugas95012063yug__as

Search took 9 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 Filter1786911340270.233766914.2
2DLD Change Limit1340271137.92316916.2
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.20221786.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.