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

107 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
surgeries1031136(None) 
buggeries1347082buggeries
forgeries13310002forgeries
nurseries948012nurseries
snuggeries1293842snuggeries
sorceries1149932sorceries
subseries11312932subseries
sureties8316582sur_eties
surgers83517482surger__s
turneries948492turneries
arteries8321483_arteries
auguries947933au_guries
bergeres1189113berger_es
burgees104915893burge__es
burgers103918573burger__s
burgesses1245513burgesses
burglaries1344193burglaries
bursaries1157643bursaries
butleries11710073butleries
butteries11711763butteries
congeries12316403congeries
currieries1244533currieries
curries93723163cur__ries
curtesies1147523curtesies
cutleries1179213cutleries
dodgeries1246593dodgeries
doggeries1246673doggeries
drudgeries1343273drudgeries
duperies11312813du_peries
durries83817353dur__ries
ferneries1239043ferneries
fulleries1248723fulleries
furmeties1446573furmeties
furrieries1343943furrieries
gorgerins1145193gorgerins
gunneries1047043gunneries
gurries83515953gur__ries
hurries103919653hur__ries
imageries1246783imageries
jaggeries18136973jaggeries
juggleries1942803juggleries
lingeries10511813lingeries
merceries13410043merceries
mummeries1247243mummeries
murderees1244353murderees
murries94118673mur__ries
nunneries947113nunneries
orreries8310123_orreries
piggeries13107893piggeries
pruderies1247873pruderies
pufferies1745203pufferies
puggries12166383pu_ggries
purgers104714003purger__s
queries16315873qu__eries
ruderies9311333ru_deries
savageries1444253savageries
sceneries1149393sceneries
sculleries1244833sculleries
scurries102911483scur__ries
sealeries9313133sealeries
sergers83815633serger__s
series64540973s___eries
serries73925353ser__ries
slaveries1249683slaveries
slurries82710413slur__ries
snuggerie1192803snuggerie_
spiceries1349313spiceries
spurries102311323spur__ries
suberins10315093su_berins
suberise10813933su_berise
suberises11813453su_berises
suberizes20811833su_berizes
subgenres1245533subgenres
submerges1446283submerges
submerses1348003submerses
subseres10312423subser_es
subserves1447183subserves
succories1347183succories
sudaries9312753su_daries
sugarier937393su_garier
sugariest1038133su_gariest
summaries13118183summaries
summerier1346423summerier
summeriest1476083summeriest
sundries9312023su_ndries
superlies11314553su_perlies
surceases1157473surceases
surfeits1146223surfe_its
surfers103614133surfer__s
surgeons947033surge_ons
surger74320093surger___
surgery11319213surger__y
surges73924593surg___es
surprise1037673sur_prise
surprises1137433sur_prises
surprizes2045593sur_prizes
surveils1144523surve_ils
thuggeries1543373thuggeries
toggeries1146213toggeries
turbaries1147743turbaries
turgencies1345513turgencies
turmerics1343833turmerics
tusheries1246893tusheries
urgencies1256643_urgencies
urgers73313623_urger__s
waggeries14127463waggeries
wiggeries14136573wiggeries

Search took 7 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 Limit1486411076.43623095.2
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.93525766.5
 
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.