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

168 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
suasion73936(None) 
suasions838781suasions
basion84315852_basion
erasion7311962erasion
evasion1036752evasion
fusion939772fu_sion
nasion63914082_nasion
pulsion938392pulsion
sasin54626572s_asi_n
scansion1045692scansion
season62714902seas_on
session739762session
stasimon1042742stasimon
station72717242station
suasive1037852suasive
suction93713042suction
sudation9310802sudation
abrasion1046623abrasion
alation72920553alation
anion55028813__anion
auction93412933auction
avion84218343__avion
avulsion1153863avulsion
axion1211316913__axion
basin75026923_basi_n
basions94213953_basions
bastion9312473_bastion
bullion91911033bullion
bunion83111313bu_nion
camion103917193_camion
casino84317553_casino
cation83925503_cation
caution93013523caution
cession939813cession
clarion9311663clarion
classon937693classon
cullion91910233cullion
cushion1236403cushion
dissuasion1143843dissuasion
duration9312693duration
durion7510963du_rion
elation73620453elation
elision72311103elision
elusion72310953elusion
emulsion1045923emulsion
enation73419233enation
equation17310483equation
erasions8310983erasions
erosion7311113erosion
evasions1136543evasions
evulsion1155063evulsion
fanion94514323_fanion
fashion1337843_fashion
fission1038733fission
fusain958643fusai_n
fusions1039153fu_sions
gabion93211033_gabion
gascon9339723_gascon
guanin7610803guani_n
invasion11115473invasion
kation104315683_kation
lesion64715063_lesion
liaison744473liaison
lunation8311923lunation
luxation1538233luxation
mansion9611543mansion
mascon103612743_mascon
mason74820183_mas_on
mission9312743mission
mullion91911173mullion
munnion935863munnion
mutation101412883mutation
nasions73112383_nasions
nation64322803_nation
nutation81513103nutation
occasion1244213occasion
oration71617713oration
outsin63617563outsi_n
ovation101510023ovation
passion9310883passion
pension9412203pension
persuasion1294193persuasion
plasmon11257983plasmon
plosion939113plosion
pulsions1037713pulsions
pupation1269503pupation
quasi144015023quasi__
quassin1645943quassin
question1745823question
ration64226013_ration
reason62616333reas_on
ruction93611613ruction
sabin74924953s_abi_n
sadiron836043s_adiron
sain45551293s_a_i_n
salmon84614183s_almon
salon55228553s_a_lon
saloon64418023s_aloon
sarin55239253s_ari_n
sasins64923103s_asins
satin55935223s_ati_n
saurian739913saurian
savin84625083s_avi_n
savior9710173s_avior
scallion1046793scallion
scansions1145323scansions
scion72214993s__cion
scission1045563scission
scullion1065633scullion
seasick1346193seasick
seaside839693seaside
seasons72614233seas_ons
section92515663section
sedation9312453sedation
seisin63715123seisi_n
sessions839723sessions
shairn9269063sha_irn
sinuation9310413sinuation
situation949423situation
slain54923573sla_i_n
solation8916153solation
solion6616383s_olion
spavin114210653spavi_n
sponsion1045623sponsion
squadron1843503squadron
stain55727943sta_i_n
stallion837523stallion
stasima955633stasima
stasis63116873stasi_s
statin63921473stati_n
stations82415223stations
suasory1046043suasory
suavity1336313suavity
subbasin1245393subbasi_n
subjoin1645443subjoin
sublation11311013sublation
subside10410453subside
subsidy1345973subsidy
subsist9311573subsist
subsite9412873subsite
subsoil967293subsoil
suctions103012903suctions
sudations1039903sudations
sudsier868783sudsier
sudsing92910323sudsing
suffusion1552773suffusion
sulcation11710733sulcation
sulfation1288783sulfation
summation1347803summation
summon1037623su_mmon
sunspot947163sunspot
sunstone847793sunstone
surgeon837003surgeon
sussing84013703sussing
swain84919053swa_i_n
symbion1464043symbion
talion6317713_talion
tension7311803tension
torsion7310803torsion
tuition738823tuition
turion6313163tu_rion
union54519793_u_nion
unison649033_unison
upsilon943583_upsilon
version10310923version
vision9311313_vision
wanion93213063_wanion
weason93210823weas_on

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.406440125.6
2DLD Change Limit1340271686.98619185.1
3Display Results1681680.0602800.0
 (SQL Overall)1786911687.45223978.9
 
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.