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

166 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
gazebo183367(None) 
gazabo1834831gazabo
gazebos1933491gazebos
gazabos1944452gazabos
gaze145032412gaze__
gazeboes2043392gazeboes
gazed165520332gaze_d
gazer155720072gaze_r
gazers164516292gazers
gazes155425912gaze_s
gazoo153112872gaz_oo
jazzbo2342712jazzbo
abo59045963_a__bo
adobo84711593_adobo
aero45435343_a_ero
agaze156113663agaze__
ambo88225133_a_mbo
ameba9312373_ameba
azido155411543_azido
azo128233393_az__o
bazoo163815673baz_oo
cameo95924993came_o
carbo94923843ca_rbo
daze147327233daze__
dazed165919363daze_d
dazes155024143daze_s
farebox1943823farebox
faze165630043faze__
fazed186222963faze_d
fazes175527213faze_s
gab67155993ga__b_
gabbed125216893gabbed
gabber114916603gabber
gabbro11114953gabbro
gabby135512943ga_bby
gabs76740423ga__bs
gaby107123193ga__by
gadjo1436913ga_djo
gae46457703ga_e__
gaed66031513ga_e_d
gaen57329603ga_e_n
gaes56348033ga_e_s
gage65936103gage__
gaged85522313gage_d
gager74726293gage_r
gagers84021323gagers
gages74529973gage_s
gaiety10119373gaiety
galago838903galago
gale56347323gale__
galea64722933gale_a
galeae74717453galeae
galeas74618503galeas
galena74911093galena
galere73716673galere
gales65442483gale_s
gamb96331843ga_mb_
gamba106018513ga_mba
gambe106219213ga_mbe
gambes116318313gambes
gambol1138223ga_mbol
gambs105721123ga_mbs
game76644323game__
gamed95126393game_d
gamely124711913gamely
gamer84928943game_r
gamers94420823gamers
games86238553game_s
gamest94919923gamest
gamete9313593gamete
gamey115320553game_y
gane55145293gane__
ganef96322463gane_f
ganefs10489203ganefs
ganev95513863gane_v
ganevs10456913ganevs
gape75134513gape__
gaped96123533gape_d
gaper86125123gape_r
gapers94520463gapers
gapes86030823gape_s
garb75332673ga_rb_
garbed104815663garbed
garbs86321413ga_rbs
gases65633993gase_s
gate55746573gate__
gateau778103gateau
gated75329773gate_d
gater64533643gate_r
gaters74728633gaters
gates65939503gate_s
gaucho1256223gaucho
gauze155712973gauze__
gauzes164710633gauze_s
gave84634053gave__
gavel95815183gave_l
gavels105911093gavels
gayer94519193gaye_r
gayest104314333gayest
gayety13116383gayety
gazaboes2043863gazaboes
gazar154612983gaz_ar
gazars164811553gazars
gazelle17236333gazelle
gazette17357363gazette
gazing174717173gazing
gazoos163010223gazoos
gazump2032453gazump
gizmo1756013giz_mo
glaze155418163glaze__
glazed174711773glaze_d
glazer164212263glaze_r
glazers174410033glazers
glazes165315643glaze_s
gleba83910243g_leba
glebe85016443g_lebe
gobo76126893g__obo
gombo105814043g_ombo
graze155820053graze__
grazed174115913graze_d
grazer164815763graze_r
grazers175112443grazers
grazes164519643graze_s
grebe85114943g_rebe
grego7310523g_rego
gumbo104413583g_umbo
haze164833393haze__
hazed185222203haze_d
hazel176414813haze_l
hazels185710083hazels
hazer174820233haze_r
hazers184615953hazers
hazes174928323haze_s
jazzbos2442033jazzbos
kazoo183311533kaz_oo
laevo849363la_evo
lavabo1135273lavabo
laze136235053laze__
lazed154925843laze_d
lazes145129573laze_s
mambo115215733ma_mbo
maze155434973maze__
mazed175523873maze_d
mazer165722423maze_r
mazers173917093mazers
mazes165632173maze_s
pageboy1543873pageboy
pareo74632603pare_o
paseo77022513pase_o
placebo1343293placebo
raze135235433raze__
razed155027983raze_d
razee145827803raze_e
razeed163710013razeed
razees154314763razees
razer144824273raze_r
razers154919613razers
razes145032703raze_s
rezero1578873rezero
sambo95118013sa_mbo
wazoo173011173waz_oo
zareba1736423zareba
zazen1337283zaze_n
zazens1435833zazens
zebu153414723__zebu
zero134822463__zero

Search took 6 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.1261418182.5
2DLD Change Limit1127161665.62620034.8
3Display Results1661660.0433860.5
 (SQL Overall)1786911665.79530835.4
 
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.