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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
bogusly134389(None) 
bogus85616472bogus__
bousy104917842bo_us_y
augustly1242153augustly
baggily1436043baggily
bassly114610073b_assly
beguile1056933beguile
begulf1238903begu_lf
bigly114814753big__ly
blousily1345193blousily
blousy11459123blous_y
bluely113310083b_luely
bodily12310993bo_dily
bogey115220233bog__ey
boggle104511943bog_gle
boggy126116073bog__gy
bogle85821683bog__le
bogs75742753bog_s__
bogy106426193bog___y
boldly12399423bo_ldly
bolshy1444883bo_lshy
bolus79125543bolus__
boluses94113833boluses
bonnily1236873bonnily
bonus75324323bonus__
bonuses94212953bonuses
boozily2135623boozily
bosky145612393bo__sky
bossily1237563bossily
bossy105515973bo__ssy
botfly1436093bo_tfly
boucle103712783bo_ucle
boule74828043bo_u_le
boulle84614613bo_ulle
bouncy13409073bo_uncy
bounty113411073bo_unty
bouse75931853bo_us_e
boused95322883bo_used
bouses84931783bo_uses
boxily1877843bo_xily
boyishly1943663boyishly
broguery1443313broguery
brushy14468263b_rushy
bully105124813b__ully
burly104922833b__urly
busby126113293b__usby
bushy135416683b__ushy
busily112211503b__usily
busty105621013b__usty
busy94727173b__us_y
doubly12328963do_ubly
dourly103210433do_urly
foggily1535053foggily
foully1239013fo_ully
goggly12337053gog_gly
gully94020683__gully
gushy125213123__gushy
gussy95314323__gussy
gusty95119573__gusty
hourly12369623ho_urly
joyously2143293joyously
logily1039833log_ily
loudly1037783lo_udly
lousily1038333lo_usily
lousy84617083lo_us_y
mogul8310213mogu_l_
moguls948553mogu_ls
mousey115216193mo_usey
mousily1239393mo_usily
mousy106716943mo_us_y
obtusely1343503obtusely
piously1236833piously
porously1347753porously
robustly1342763robustly
roguery1134893roguery
roguishly1642973roguishly
roughly14507293roughly
soggily1235953soggily
solubly1255283solubly
sourly93612203so_urly
thusly1235133_thusly
toughly14487433toughly
tousle64514653to_usle
vaguely1443693vaguely
voguishly1942683voguishly
volubly1543553volubly
wofully1644523wofully

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027877.20318607.1
3Display Results87870.0332636.4
 (SQL Overall)178691877.39224173.6
 
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.