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

142 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
suasive103785(None) 
assuasive1242622assuasive
cursive1237832cursive
evasive1344662evasive
jussive1734292jussive
seaside839692seaside
stative102612932stative
suasion739362suasion
suasively1544482suasively
suave83519872sua__ve
subside10410452subside
subsite9412872subsite
survive1335932survive
tussive1035302tussive
abrasive1345753abrasive
abusive1245283abusive
alive85722513__alive
amative12311733amative
amusive1246253amusive
aside65122083__aside
cuisine9310423cuisine
curative13310403curative
cursives1337103cursives
dative10311813_dative
dissuasive1453123dissuasive
dualize1759763dualize
durative1239073durative
elative10312453elative
elusive1057003elusive
emulsive1344533emulsive
erosive1039193erosive
furtive1337173furtive
fusile94313493fu_sile
glaive10357933gla_ive
guanine8810543guanine
gussie72910153gussi_e
invasive1444833invasive
jussives1833843jussives
massive12289773massive
missive122413143missive
mutative1348283mutative
naive85116213_na_ive
native9613013_native
outgive11199253outgive
outlive102513033outlive
outside82414193outside
outsize162411753outsize
passive12239593passive
pensive122610393pensive
persuasive1553683persuasive
plausive1344583plausive
plosive1236673plosive
putative1348373putative
quasi144015023quasi__
quayside2143473quayside
rusine63916593ru_sine
sabine84020393s_abine
saice75424053s_a_ice
saline65132703s_aline
saliva93110743s_aliva
salve85022133s_a_lve
samite83020603s_amite
sanative11310473sanative
sasin54626573s_asi_n
sasins64923103s_asins
satire63218003s_atire
sausage847193sausage
save75741363s_a__ve
savine94220283s_avine
scrive115414943s_crive
seasick1346193seasick
seasides938743seasides
sedative1238853sedative
sessile739523sessile
shave114425893sha__ve
shavie124312423shavi_e
shive114423423s__hive
shrive125216953s_hrive
skive124614113s__kive
skydive1852773skydive
slave84224033sla__ve
soave84219053soa__ve
sonsie6614863sonsi_e
spavie113611383spavi_e
stabile9312063stabile
stanine73417073stanine
starve94613743sta_rve
stasima955633stasima
stasis63116873stasi_s
statice92614033statice
statives112710793statives
stave85324993sta__ve
strive95020963s_trive
suable83920553sua_ble
suasions838783suasions
suasory1046043suasory
suaver93014233sua__ver
suavity1336313suavity
subfile122010503subfile
sublime11310363sublime
subline9316893subline
subsale9310543subsale
subsere9311443subsere
subserve1346473subserve
subsided1257663subsided
subsider1138243subsider
subsides11410823subsides
subsidy1345973subsidy
subsist9311573subsist
subsites10312783subsites
subsume1146713subsume
subtile91912623subtile
sudsier868783sudsier
sudsing92910323sudsing
suffice15197573suffice
suffusive1852373suffusive
suicide1038893suicide
suite54829563su__ite
sulfide1138103sulfide
sulfite10310473sulfite
summative1646203summative
sunlike112310573sunlike
sunrise7310813sunrise
sunshine1147923sunshine
sunwise1036433sunwise
supine84216693su_pine
surfside1244853surfside
surmise9311083surmise
survived1534073survived
surviver1434683surviver
survives1436333survives
suspire937803suspire
sussing84013703sussing
swive115316193s__wive
tensive10269913tensive
unlive92712333_unlive
updive1234903_updive
upside9289803_upside
upsize17267303_upsize
ursine64114123_ursine
visive1257873_visive
waive114214603_wa_ive

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271427.16018718.9
3Display Results1421420.0463087.0
 (SQL Overall)1786911427.60923484.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.