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

97 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
snottily114555(None) 
knottily1543151knottily
snootily1136251snootily
spottily1335151spottily
dottily1147282_dottily
nattily103610322_nattily
nuttily10308632_nuttily
smuttily1344272smuttily
snobbily1544232snobbily
snoopily1345552snoopily
snottier8217382snottier
snotty9489202snott__y
snowily1336882sno_wily
sootily101810522s_ootily
sportily1337732sportily
cattily123210853_cattily
chattily1634603chattily
fattily13379463_fattily
frostily1436693frostily
frothily1745303frothily
goutily1137933_goutily
grittily1244183grittily
joltily1746323_joltily
knottier12203983knottier
knotting13236573knotting
knotty13315223knott__y
loftily1336353_loftily
nastily103011033_nastily
nettly9459453_nett_ly
niftily1335753_niftily
nobbily1436693_nobbily
noily86120993_no__ily
noisily1038403_noisily
nonoily1049543_nonoily
nosily93712683_no_sily
notably12199993_notably
notedly1136883_notedly
notify1236943_no_tify
pettily1238173_pettily
prettily1337283prettily
ruttily10338613_ruttily
saltily10310543s_altily
scantily1337583scantily
scottie937463scotti_e
scotties1039753scotties
shiftily1744553shiftily
shoddily1643573shoddily
shortly13387573short_ly
shotting123012383shotting
showily1636223sho_wily
sloppily1544613sloppily
slotting92612613slotting
smokily1635373smo_kily
smoothly16203643smoothly
snakily1436913sn_akily
snappily1544323snappily
snarkily1534583snarkily
sneakily1544423sneakily
sniffily17154033sniffily
snippily1543573snippily
snootier8278383snootier
snooting92813203snooting
snooty94211513snoot__y
snorting92613373snorting
snottiest9167973snottiest
snoutier8206973snoutier
snouting92511923snouting
snoutish1145783snoutish
snouty9419953snout__y
snuffily17124323snuffily
soapily1237963s_oapily
softly12457763s_oft_ly
soggily1235953s_oggily
soothly13186923s_oothly
sorrily1039833s_orrily
sottedly1244303s_ottedly
sottish10129443s_ottish
sottishly1543763s_ottishly
spongily1444903spongily
spookily1744173spookily
spoonily1335233spoonily
spottier10207313spottier
spotting112812093spotting
spotty11448583spott__y
squattily2142653squattily
stockily1735443stockily
stodgily1343903stodgily
stonily1049433sto_nily
stormily1345243stormily
stotting92811163stotting
stoutly1035833stout_ly
sultrily1146493sultrily
sweatily1435473sweatily
swotting12268483swotting
tattily10409993_tattily
toothily1445523toothily
wittily1336173_wittily

Search took 10 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 Limit146162978.69016819.6
3Display Results97970.0303233.3
 (SQL Overall)178691979.14019550.4
 
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.