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

72 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
sundrops114582(None) 
gumdrops1442822gumdrops
outdrops1136542outdrops
sundogs947102sund_ogs
sundress936982sundress
sundries9312022sundries
airdrops1144343airdrops
andros7313303_andro_s
dendrons1047393dendrons
dewdrops1542963dewdrops
drops85719503___drops
eardrops1165303eardrops
eyedrops1443163eyedrops
gumdrop1342513gumdrop_
gundogs1034603gund_ogs
hundreds1344003hundreds
hydrops16197413_hydrops
outcrops1246853outcrops
outdrop1036193outdrop_
pinedrops1443353pinedrops
raindrops1242813raindrops
sandhogs1365483sandhogs
sandlots938293sandlots
sandsoaps1243683sandsoaps
sannops936693san_nops
sendups10115193send_ups
snoops84314173s_n_oops
snowdrops1542113snowdrops
sonorous8410413sonorous
squadrons1943253squadrons
strops86220383s__trops
suberous10311793suberous
subgroups1442493subgroups
sudors7311103su_d_ors
sunbows1236023sun_bows
sundaes8313093sund_aes
sundecks1544253sundecks
sunderers1039073sunderers
sunders84120053sund_ers
sundews11398153sund_ews
sundials946753sundials
sundog837613sund_o_g
sundown1186313sund_own
sundowns1285433sundowns
sundrily1246063sundrily
sundry1057943sundr__y
sunglows1244083sunglows
sunlamps1243293sunlamps
sunproof1344603sunproof
sunrays1037083sun_rays
sunroof1047053sun_roof
sunroofs1144763sunroofs
sunroom947013sun_room
sunrooms1045723sunrooms
sunspots1045083sunspots
sunups837263sun__ups
supercops1547733supercops
syndrome1444293syndrome
syndromes1544503syndromes
tundras857113tundr_as
uncross938193_uncross
undoes73917403_und_oes
undrape1049333_undrape
undrapes1138603_undrapes
undraws1136893_undraws
undress838893_undress
unrips8199453_un_rips
unstops936993_unstops
unwraps1255513_unwraps
upprops1044223_upprops
windrows1546163windrows
wondrous1246823wondrous

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.420425454.8
2DLD Change Limit146162727.25020160.3
3Display Results72720.0332181.8
 (SQL Overall)178691727.70323197.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.