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

94 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
buggeries134708(None) 
beggaries1356232beggaries
buggered1335622bugger_ed
buggering1435192buggering
buggers114315662bugger__s
buggies114613812bugg__ies
butleries11710072butleries
butteries11711762butteries
doggeries1246672doggeries
jaggeries18136972jaggeries
juggleries1942802juggleries
piggeries13107892piggeries
puggries12166382pugg_ries
snuggeries1293842snuggeries
surgeries10311362surgeries
thuggeries1543372thuggeries
toggeries1146212toggeries
waggeries14127462waggeries
wiggeries14136572wiggeries
auguries947933au_guries
baggers113915693bagger__s
baggies113814853bagg__ies
bakeries14312193b_akeries
batteries11615113batteries
beaneries11310903beaneries
bergeres1189113berger_es
bibberies1297133bibberies
biggies113813523bigg__ies
bigotries1286443bigotries
binderies12311683binderies
biogenies1248513biogenies
bobberies12107893bobberies
boiseries11411043boiseries
booteries11312773booteries
boweries13312293b_oweries
braveries1439103braveries
breweries1447583breweries
briberies1348333briberies
brogueries1344813brogueries
budgers114314923budger__s
budgies115312513budg__ies
bugeyes1335513bu_ge_yes
bugger104418723bugger___
buggery14367933bugger__y
buggier113611343bugg__ier
buggiest123410363bugg__iest
buglers105115323bugler__s
bulgers105215143bulger__s
bungees104513103bunge__es
burgees104915893burge__es
burgers103918573burger__s
burgesses1245513burgesses
burglaries1344193burglaries
buries84633273bu___ries
bursaries1157643bursaries
butcheries1745073butcheries
butterier1177453butterier
butteriest1276883butteriest
congeries12316403congeries
cutleries1179213cutleries
dodgeries1246593dodgeries
drudgeries1343273drudgeries
duperies11312813du_peries
forgeries13310003forgeries
fulleries1248723fulleries
groggeries1354703groggeries
gunneries1047043gunneries
huggers124211593hugger__s
humbuggeries2161133humbuggeries
imageries1246783imageries
jaggaries18135743jaggaries
jaggheries2242423jaggheries
lingeries10511813lingeries
luggers93713483lugger__s
luggies93011213lugg__ies
muggees11338883mugge__es
muggers113611933mugger__s
mummeries1247243mummeries
nunneries947113nunneries
nurseries948013nurseries
priggeries1444993priggeries
pufferies1745203pufferies
puggarees13173043puggarees
puggrees12194263pugg_rees
queries16315873qu__eries
rogueries1047003rogueries
ruderies9311333ru_deries
ruggedizes2251703ruggedizes
ruggers94612313rugger__s
snuggerie1192803snuggerie_
subseries11312933subseries
tuggers93711443tugger__s
turneries948493turneries
tusheries1246893tusheries

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 Filter1786911486410.453394461.4
2DLD Change Limit148641946.78321913.8
3Display Results94940.0432186.0
 (SQL Overall)178691947.27924548.8
 
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.