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 “sparsely” 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
sparsely133512(None) 
sparely123410671spar_ely
coarsely1335532coarsely
hoarsely1444362hoarsely
parsley1247792_parsley
scarcely1534312scarcely
sparkily1735022sparkily
sparkly16348132spar_kly
sparse84516342sparse__
sparser94311482sparse_r
sparsest1048812sparsest
sparsity1345462sparsity
aversely1444853aversely
barely114716793_bar_ely
basely114412313_ba_sely
falsely1336013_falsely
harshly1636273_harshly
largely1136703_largely
opaquely2241503opaquely
operosely1443273operosely
paisley1235553_paisley
palely11311923_pa_lely
parcel103915473_parcel_
parcels113712663_parcels
parley116718353_parle_y
parrel84515983_parrel_
parrels94713493_parrels
parse75236993_parse__
parsec105914483_parse_c
parsecs11429923_parsecs
parsed96323893_parse_d
parser84822373_parse_r
parsers94118153_parsers
parses85534703_parse_s
parsleys1335083_parsleys
partly116315473_par_tly
passel85117003_passel_
passels93913023_passels
purely114013623_pur_ely
pursily1238213_pursily
rarely93513653_rar_ely
safely12249393s_a_fely
sagely102811383s_a_gely
sanely93114613s_a_nely
sarsen6314233s_arse_n
sarsens7311393s_arsens
sassily1038723s_assily
scarey115016983scar_e_y
scarily12311703scar_ily
separably1655773separably
separately1553433separately
shapely1536893sha_pely
sharply15406833shar_ply
smarmily1543523smarmily
smartly12497433smar_tly
snarkily1534583snarkily
snarly93815003snar__ly
sorely94618013s_or_ely
spacey136212533spa_ce_y
spancel1147363spancel_
spancels1245273spancels
spangly1336473spa_ngly
spaniel948923spaniel_
spaniels1045963spaniels
spansule1043623spansule
sparable121611983sparable
spare75135563spar_e__
spared95427493spar_e_d
sparer84524963spar_e_r
sparers94519613spar_ers
spares84834553spar_e_s
sparest94616423spar_est
sparge94216053sparge__
sparged113512763sparge_d
sparger103613083sparge_r
spargers11389733spargers
sparges104016343sparge_s
sparingly1537283sparingly
sparked143513143sparke_d
sparker133914363sparke_r
sparkers144111313sparkers
sparkle133710213spar_kle
sparkled15317733sparkled
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparky154511523spar__ky
sparred104512863sparre_d
sparry115111303spar__ry
spars75431543spars___
spinosely1442533spinosely
spirally1348023spirally
sportily1337733sportily
sprawly15166043sp_rawly
sprucely1543123sprucely
spryly1435513sp_r_yly
spurrey12307813spurre_y
squarely2045353squar_ely
stalely1039213sta_lely
starkly14277033star_kly
stately10310223sta_tely
suavely1376493sua_vely
supersell1147063supersell
surely93816463s_ur_ely
tersely1038103_tersely
weasely13317853wea_sely
yarely122810303_yar_ely

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.1561145455.1
2DLD Change Limit1461621076.43622710.1
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.63826919.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.