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 “snootily” 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
snootily113625(None) 
snoopily1345551snoopily
snottily1145551snottily
sootily101810521s_ootily
knottily1543152knottily
smoothly16203642smoothly
snobbily1544232snobbily
snootier8278382snootier
snooting92813202snooting
snooty94211512snoot__y
snowily1336882sn_owily
soothly13186922s_oothly
spookily1744172spookily
spoonily1335232spoonily
sportily1337732sportily
spottily1335152spottily
bloodily1445183bloodily
boozily2135623_boozily
broodily1445503broodily
doomily1336133_doomily
dottily1147283_dottily
droopily1443943droopily
frostily1436693frostily
gloomily1443753gloomily
goofily14105353_goofily
goutily1137933_goutily
joltily1746323_joltily
loftily1336353_loftily
loonily1037073_loonily
loopily1236803_loopily
moodily1358203_moodily
moonily1248943_moonily
nastily103011033_nastily
nattily103610323_nattily
niftily1335753_niftily
nobbily1436693_nobbily
noily86120993_n_o_ily
noisily1038403_noisily
nonoily1049543_nonoily
nosily93712683_n_osily
notify1236943_n_otify
nuttily10308633_nuttily
oozily18328073__oozily
roomily1237283_roomily
saltily10310543s_altily
savorily1445043savorily
scantily1337583scantily
scooting113012643scooting
serotiny1148573serotiny
shiftily1744553shiftily
shoddily1643573shoddily
shoofly1634353shoo_fly
shooting122812863shooting
shortly13387573short_ly
showily1636223s_howily
sloppily1544613sloppily
smokily1635373s_mokily
smoothy15205083smoot_hy
smuttily1344273smuttily
snakily1436913sn_akily
snappily1544323snappily
snarkily1534583snarkily
sneakily1544423sneakily
sniffily17154033sniffily
snippily1543573snippily
snooding102910433snooding
snooking133010583snooking
snool55118643snoo__l_
snooling93013473snooling
snools65715883snoo__ls
snoopier10177273snoopier
snooping113811323snooping
snoopy11449473snoo__py
snoot55030143snoot___
snooted84213283snoot_ed
snootiest9178753snootiest
snoots64216683snoot__s
snoozier17185193snoozier
snoozing18319083snoozing
snoozle16305913snoo_zle
snoozy18517233snoo__zy
snorting92613373snorting
snottier8217383snottier
snotty9489203sn_ot_ty
snoutier8206973snoutier
snouting92511923snouting
snoutish1145783snoutish
snouty9419953snout__y
snuffily17124323snuffily
soapily1237963s_oapily
softly12457763s_oft_ly
soggily1235953s_oggily
sonority1148533sonority
sootier73916613s_ootier
sooting82820963s_ooting
sooty84924843s_oot__y
sorrily1039833s_orrily
spongily1444903spongily
stockily1735443stockily
stodgily1343903stodgily
stonily1049433s_tonily
stormily1345243stormily
stoutly1035833stout_ly
sweatily1435473sweatily
toothily1445523_toothily
unholily1444133unholily
woozily2234383_woozily

Search took 9 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.406440125.6
2DLD Change Limit1461621077.81318707.5
3Display Results1071070.0303566.7
 (SQL Overall)1786911078.24921662.1
 
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.