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

157 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
scantily133758(None) 
scantly12419551scant_ly
cannily1239262_cannily
cattily123210852_cattily
saltily10310542s_altily
scabbily1763942scabbily
scantier10309982scantier
scanties103215422scanties
scanting113914762scanting
scanty114014662scant__y
scarily12311702sca_rily
secantly1345982secant_ly
slangily1235382slangily
slantly10399322slant_ly
swankily1833832swankily
anticly12410053__anticly
artily92814713__artily
cagily12411563_ca_gily
campily1638273_campily
candidly1545213_candidly
cantal84122033_cantal_
cantala94114673_cantala
cantals93919573_cantals
cantic103920543_canti_c
canticle1239703_canticle
cantina93417253_cantina
canting104725903_canting
cantle84522153_cant_le
canty105226803_cant__y
centile94217183_centile
chancily1845243chancily
chattily1634603chattily
craftily1644783craftily
crankily1755623crankily
daintily1245523daintily
dandily12279633_dandily
draftily1534413draftily
fancily1538253_fancily
fattily13379463_fattily
flauntily1542653flauntily
flintily1434893flintily
franticly1744013franticly
handily143610873_handily
hastily133010663_hastily
heartily1436563heartily
jauntily1834173jauntily
lankily1437123_lankily
mangily1339753_mangily
manlily1238743_manlily
meatily12311093mea_tily
nastily103011033_nastily
nattily103610323_nattily
pantile93918483_pantile
quantify2343863quantify
quantile1747323quantile
quantity2044733quantity
riantly1037613riant_ly
saintly1039343saint_ly
sanctify1644493s_anctify
sanctity1345593s_anctity
sandfly1435643s_andfly
sanely93114613s_an_ely
sanity9316203s_an_ity
santimi938793s_antimi
santims9312603s_antims
santimu938563s_antimu
santir6315253s_anti_r
santirs7312963s_antirs
santol64515243s_antol_
santols73513323s_antols
sappily1437163s_appily
sassily1038723s_assily
satiny93817983s_a_tiny
saucily1237913s_aucily
savvily1634323s_avvily
scalably15166703scalably
scaly104718723sca___ly
scandal1038673scandal_
scandals1136993scandals
scandia1038063scandi_a
scandias1137863scandias
scandic1237003scandi_c
scandium1365693scandium
scanning113310773scanning
scansion1045693scansion
scant79735073scant___
scanted104114393scant_ed
scanter94215183scant_er
scantest101710183scantest
scantiest112611003scantiest
scantling12107233scantling
scants85219723scant__s
scarcely1534313scarcely
scarcity1545093scarcity
scarify1537443sca_rify
scarting113415263scarting
scattier10267583scattier
scatting113311813scatting
scatty115310653sca_t_ty
scenting113212813scenting
scintilla1153753scintilla
scraggily1642663scraggily
scrappily1842673scrappily
scrutiny1344773scrutiny
scummily1743303scummily
scurvily1643783scurvily
shabbily1873903shabbily
shadily1437723sha_dily
shaggily1643773shaggily
shakily1736903sha_kily
shantey134210043shant_ey
shanti94014093shanti__
shanties113116583shanties
shantih13309643shanti_h
shantihs14276213shantihs
shantis103313103shanti_s
shanty124715123shant__y
shiftily1744553shiftily
shinily13268933shin_ily
slanting94115093slanting
slantingly1445143slantingly
slanty95114843slant__y
slinkily1534853slinkily
smarmily1543523smarmily
smartly12497433smart_ly
smuttily1344273smuttily
snakily1436913sna_kily
snappily1544323snappily
snarkily1534583snarkily
snootily1136253snootily
snottily1145553snottily
soapily1237963soa_pily
sootily101810523s_ootily
spangly1336473span_gly
sparkily1735023sparkily
spongily1444903spongily
sportily1337733sportily
spottily1335153spottily
spunkily1733773spunkily
squattily2142653squattily
stagily1139053sta_gily
stalkily1534823stalkily
stanchly1644443stanchly
stately10310223sta_tely
stingily1236793stingily
stonily1049433ston_ily
sunnily1037833s_unnily
swarthily1842583swarthily
sweatily1435473sweatily
tantivy1335563_tantivy
tartily103511573_tartily
tastily103311643_tastily
tattily10409993_tattily
uncannily1443453uncannily
vacantly1644063vacant_ly
yeastily1444573yeastily
zanily18310183_zan_ily

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.1531167915.0
2DLD Change Limit1461621578.36017483.5
3Display Results1571570.0632492.1
 (SQL Overall)1786911578.57620836.2
 
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.