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

92 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
saggaring1223624(None) 
saggering12197791saggering
beggaring1435182beggaring
daggering13246112daggering
hangaring1438032hangaring
sagging103116102sagg__ing
staggering13194582staggering
sugaring1039052s_ugaring
swaggering16233622swaggering
aggrading1344843_aggrading
anearing9413973_anearing
angering102113803_angering
ashlaring1344493ashlaring
auguring1036383_auguring
badgering1436963badgering
bagging123316983bagg__ing
buggering1435193buggering
daggling12237063dagg_ling
dangering12239303dangering
dogearing1235763dogearing
fagging133714763fagg__ing
faggoting1543313faggoting
gagging93013533gagg__ing
gaggling10217463gagg_ling
gearing92818843__gearing
glaring93714883__glaring
hagging133114683hagg__ing
haggling14227273hagg_ling
jaggaries18135743jaggaries
jagging173311993jagg__ing
jiggering1934303jiggering
laagering1136833laagering
lagering102212313la_gering
lagging103316743lagg__ing
margarin1148073margarin_
margarine1247713margarine
margarins1248293margarins
nagging102613043nagg__ing
niggarding1442353niggarding
ragging103516683ragg__ing
regearing112211413regearing
sabering112113743sa_bering
sabring102614843sa__bring
sacring103115983sa__cring
safariing1344553sa_fariing
saggar84010853saggar___
saggard10358953saggar__d
saggards11397493saggar_ds
saggared11326063saggar_ed
saggars93610683saggar__s
salaaming1265363salaaming
salarying1336073sa_larying
salvaging1465283salvaging
sambaing1337113samba_ing
sandaling112010563sandaling
sashaying1644593sashaying
satiating10311813satiating
saunaing937013sauna_ing
savaging1356673sa_vaging
savarin10310003sa_varin_
savarins1139893sa_varins
savoring1269483sa_voring
savouring1335193savouring
scaring103421973s__caring
seafaring1345963seafaring
searing83330923s__earing
shagging14349053shagg__ing
sharing113723243s__haring
shearing123915903s_hearing
signaling1136563signaling
slagging113711583slagg__ing
smearing113511753s_mearing
snagging11319373snagg__ing
snaring83920953s__naring
sniggering1343763sniggering
soaring83521893s__oaring
sparing104823873s__paring
spearing113216103s_pearing
squaring18158633s_quaring
stagging113310513stagg__ing
stagnating1254973stagnating
stargazing2193323stargazing
staring84527053s__taring
swagging14328093swagg__ing
swearing123711443s_wearing
tagging103014913tagg__ing
wagering13219523wa_gering
wagging133313353wagg__ing
waggling14197063wagg_ling
waggoning1543593waggoning
wayfaring1942513wayfaring
zagging193210453zagg__ing

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.423422437.4
2DLD Change Limit148641926.82621775.7
3Display Results92920.0501840.0
 (SQL Overall)178691927.29924481.6
 
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.