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

131 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
burgeons114605(None) 
bourgeons1244391bourgeons
burgeon1036431burgeon_
surgeons947031surgeons
bludgeons1342802bludgeons
bourgeois1243742bourgeois
bourgeon1144682bourgeon_
burdens1039712burde_ns
burgees104915892burge_es
burgeoned1343702burgeoned
burgers103918572burge_rs
burgess10409342burge_ss
burgoos1037122burg_oos
burtons9310852bur_tons
dudgeons11163942dudgeons
dungeons10124622dungeons
gudgeons11113942gudgeons
sturgeons1043392sturgeons
surgeon837002surgeon_
argons75018203_arg_ons
bargains1178643bargains
bargees105415873barge_es
barges94528253barge__s
barons85025383bar__ons
barrens94414323barre_ns
baryons121010473bar_yons
barytons1345573barytons
bergeres1189113bergeres
biogens1038963bioge_ns
bludgeon1242923bludgeon_
boreens9310403bor_eens
borneols1046343borneols
borons85520543bor__ons
bourbons1245343bour_bons
bourdons1136433bour_dons
bourgeoise1352863bourgeoise
bourgeoned1452543bourgeoned
brens75823363b_r_e_ns
buckeens1634853buckeens
budgers114314923budge_rs
budges104820133budge__s
budgets11489863budge_ts
buffoons1643093buffoons
bugeyes1335513bu_geyes
buggers114315663bugge_rs
bugloss1035893bu_gloss
bulgers105215143bulge_rs
bulges95919323bulge__s
bullions101710043bullions
bungees104513103bunge_es
bunions92210473bu_nions
burans85019303bur__ans
burbots1168673bur_bots
burden9412473burde_n_
bureaus979293bur_eaus
burets84321263bur_e_ts
burgages1236483burgages
burgee97120593burge__e
burgeoning1443103burgeoning
burger94020793burge__r
burgesses1245513burgesses
burghers1435633burghers
burghs12519923burg__hs
burglars1154593burglars
burgles105615963burg_les
burgling12239303burgling
burgonet1148103burg_onet
burgonets1243513burg_onets
burgoo938933burg_o_o
burgout1049773burg_out
burgouts1145123burgouts
burgs84924093burg___s
buriers94017193burie_rs
buries84633273burie__s
burins84221893bur__ins
burkers133716623burke_rs
burkes124421313burke__s
burlers94120273burle_rs
burlesks1443223burlesks
burleys12479673burle_ys
burners94115673burne_rs
burnets93813263burne_ts
burnous938823bur_nous
burns74926783bur___ns
burrers93814493burre_rs
burros85114993bur_ro_s
burrows12399093bur_rows
burseeds1134783burseeds
burses84425513burse__s
burstone1057133burstone
burstones1187153burstones
burthens1335383burthens
burton8311273bur_ton_
burweeds1434103burweeds
buteos84913413bu_teo_s
buttons9310333bu_ttons
dudgeon10134143dudgeon_
dungeon9134553dungeon_
durions839963dur_ions
fourgons1234833fourg_ons
gorgeous1046293gorgeous
gorgons938853gorg_ons
gudgeon10123743gudgeon_
gurges84716863gurge__s
habergeons1691843habergeons
hugeous1137133hu_geous
jargons1558203jarg_ons
jargoons1644663jargoons
kurgans12145653kurg_ans
lorgnons943993lorgnons
morgens10310463morge_ns
mureins9310733mur_eins
nucleons1065483nucleons
pereons92815003per_eons
pigeons1039183_pigeons
purgers104714003purge_rs
purges94421763purge__s
sturgeon943303sturgeon_
surgers83517483surge_rs
surges73924593surge__s
trudgeons11202843trudgeons
tureens7289873tur_eens
turgent8712393turge_nt
turgors836833turg_ors
turions7311573tur_ions
turnons737863tur_nons
urgent73816043_urge_nt
urgers73313623_urge_rs
urges64619913_urge__s
widgeons1343853widgeons
wigeons1136983_wigeons

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621317.28320068.9
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.75223051.0
 
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.