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 “snoopily” 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
snoopily134555(None) 
snootily1136251snootily
droopily1443942droopily
loopily1236802_loopily
sloppily1544612sloppily
snappily1544322snappily
snippily1543572snippily
snobbily1544232snobbily
snoopier10177272snoopier
snooping113811322snooping
snoopy11449472snoop__y
snottily1145552snottily
snowily1336882sn_owily
soapily1237962s_oapily
sootily101810522s_ootily
spookily1744172spookily
spoonily1335232spoonily
bloodily1445183bloodily
boozily2135623_boozily
broodily1445503broodily
choppily2044133choppily
croupily1544743croupily
doomily1336133_doomily
dopily123510463__dopily
floppily1843773floppily
gloomily1443753gloomily
goofily14105353_goofily
knottily1543153knottily
loonily1037073_loonily
monopoly1546823monopoly
moodily1358203_moodily
moonily1248943_moonily
nippily1444713_nippily
nobbily1436693_nobbily
noily86120993_n_o_ily
noisily1038403_noisily
nonoily1049543_nonoily
nosily93712683_n_osily
oozily18328073__oozily
roomily1237283_roomily
ropily113312443__ropily
roupily1246653_roupily
sappily1437163s_appily
savorily1445043savorily
scooping133610633scooping
shoddily1643573shoddily
shoofly1634353shoo_fly
showily1636223s_howily
skimpily1963053skimpily
sleepily1344823sleepily
slippily1544193slippily
smokily1635373s_mokily
smoothly16203643smoothly
snakily1436913sn_akily
snarkily1534583snarkily
sneakily1544423sneakily
sniffily17154033sniffily
snooding102910433snooding
snooking133010583snooking
snool55118643snoo__l_
snooling93013473snooling
snools65715883snoo__ls
snoop75317173snoop___
snooped103711813snoop_ed
snooper93511533snoop_er
snoopers10319843snoopers
snoopiest11157063snoopiest
snoops84314173snoop__s
snootier8278383snootier
snooting92813203snooting
snooty94211513snoo__ty
snoozier17185193snoozier
snoozing18319083snoozing
snoozle16305913snoo_zle
snoozy18517233snoo__zy
snuffily17124323snuffily
soggily1235953s_oggily
sonority1148533sonority
soothly13186923s_oothly
sorrily1039833s_orrily
spongily1444903spongily
sportily1337733sportily
spottily1335153spottily
stockily1735443stockily
stodgily1343903stodgily
stonily1049433s_tonily
stooping113012363stooping
stormily1345243stormily
swoopier13175143swoopier
swooping14338403swooping
swoopy14487283swoop__y
unholily1444133unholily
woozily2234383_woozily
zoophily2544913_zoophily

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 Limit146162947.26620115.9
3Display Results94940.0332848.5
 (SQL Overall)178691947.71923149.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.