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

109 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
spottily133515(None) 
snottily1145551snottily
sportily1337731sportily
dottily1147282_dottily
knottily1543152knottily
pettily1238172_pettily
smuttily1344272smuttily
snootily1136252snootily
sootily101810522s_ootily
spongily1444902spongily
spookily1744172spookily
spoonily1335232spoonily
spottier10207312spottier
spotting112812092spotting
spotty11448582spott__y
apostil947903apostil_
apostils1046773apostils
cattily123210853_cattily
chattily1634603chattily
fattily13379463_fattily
frostily1436693frostily
frothily1745303frothily
goutily1137933_goutily
grittily1244183grittily
joltily1746323_joltily
loftily1336353_loftily
nattily103610323_nattily
nuttily10308633_nuttily
pithily1567033_pithily
pockily1846233_pockily
podgily1435213_podgily
pokily15309063_po_kily
pontil8315463_pontil_
pontils9312213_pontils
portly114713403_port_ly
pottery123011073_pottery
pottier93516493_pottier
potties93723543_potties
potting103720893_potting
pottle84416103_pott_le
potty105621003_pott__y
prettily1337283prettily
ruttily10338613_ruttily
saltily10310543s_altily
scantily1337583scantily
scottie937463scotti_e
scotties1039753scotties
shiftily1744553shiftily
shoddily1643573shoddily
shortly13387573short_ly
shotting123012383shotting
showily1636223sho_wily
sloppily1544613sloppily
slotting92612613slotting
smokily1635373smo_kily
smoothly16203643smoothly
snobbily1544233snobbily
snoopily1345553snoopily
snottier8217383snottier
snotty9489203snott__y
snowily1336883sno_wily
soapily1237963s_oapily
softly12457763s_oft_ly
soggily1235953s_oggily
soothly13186923s_oothly
sorrily1039833s_orrily
sottedly1244303s_ottedly
sottish10129443s_ottish
sottishly1543763s_ottishly
sparkily1735023sparkily
spatting113111763spatting
speedily1465183speedily
spicily1438653sp_icily
spiffily19153483spiffily
spikily1635873sp_ikily
spitting113012323spitting
spittle937923spitt_le
spoil75818653spo__il_
spoils84614533spo__ils
spoilt85016593spo__ilt
sportier102010053sportier
sportif1238803sporti_f
sporting112415463sporting
sportingly1645543sportingly
sportive1348333sportive
sportively1845023sportively
sporty115112493sport__y
spotlit947303spotli_t
spottable1345343spottable
spotted103713143spott_ed
spotter94514883spott_er
spotters104313383spotters
spottiest11177683spottiest
spouting113511953spouting
spunkily1733773spunkily
sputtery13366473sputtery
squattily2142653squattily
stockily1735443stockily
stodgily1343903stodgily
stonily1049433sto_nily
stormily1345243stormily
stotting92811163stotting
stoutly1035833stout_ly
sultrily1146493sultrily
sweatily1435473sweatily
swotting12268483swotting
tattily10409993_tattily
toothily1445523toothily
wittily1336173_wittily

Search took 7 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.423422437.4
2DLD Change Limit1461621096.45322650.2
3Display Results1091090.0303633.3
 (SQL Overall)1786911096.90625874.7
 
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.