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

178 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
seriation931806(None) 
seriations10316681seriations
serration9414071serration
striation9313481striation
aeration8319932aer_ation
derivation14712782derivation
deviation13312392deviation
herniation1348442herniation
mediation12312292mediation
nervation12610242nervation
satiation9313432satiation
sedation9312452se_dation
sedition939332sedi_tion
sensation9510582sensation
seriatim1049222seriati_m
seriating10916402seriating
serrations10313102serrations
speciation1449392speciation
striations10312792striations
striction1148982striction
variation12312392variation
vernation12311082vernation
aberration1267203aberration
aerations9317903aer_ations
ascription1444993ascription
aspiration1249993aspiration
aviation11312743_aviation
carnation11312943carnation
ceratin93020163cer_ati_n
cessation1176853cessation
ciliation111112493ciliation
creation102816513_creation
cremation13511643cremation
crenation11412923crenation
darnation1039823darnation
dealation10313003dealation
decimation15411623decimation
dedication14311963dedication
deflation13310653deflation
delation92318083de_lation
dentation10315243dentation
depiction1437273depiction
depilation13312033depilation
deprivation1788773deprivation
derision939073deri_sion
derivations15611493derivations
derogation12410393derogation
detrition1049133detri_tion
deviations14311163deviations
duration9312693dur_ation
edition8310853_edi_tion
elation73620453_e_lation
enation73419233_e_nation
enervation1369473enervation
epilation11312963_epilation
equation17310483_equation
erasion7311963_er_asion
erection102115513_erection
eruption1047043_eruption
estimation12410843estimation
estivation1349813estivation
eviction13228683_eviction
expiation18710423expiation
fellation1238843fellation
fetation11613143fe_tation
filiation121110243filiation
floriation1367793floriation
foliation121110793foliation
formation1439423formation
friction1347913_friction
furcation1448353furcation
gelation93014433ge_lation
gemination131410663gemination
gemmation1445963gemmation
germination14148973germination
gestation10310663gestation
gyration1237763gyr_ation
herniations1447403herniations
hesitation1349633hesitation
inebriation1357243inebriation
irrigation1147803irrigation
irritation1048973irritation
iteration9515033iter_ation
keratin113314153ker_ati_n
legation92412933le_gation
lenition8310083leni_tion
levigation1447023levigation
levitation1349443levitation
marination12312813marination
mediations13310983mediations
medication15411173medication
meditation13410743meditation
mentation11313983mentation
metrication15410653metrication
narration9310063narration
negation92913023ne_gation
nervations1359483nervations
observation1665063observation
obviation1446093obviation
operation11314003oper_ation
oration71617713_or_ation
peltation11312963peltation
perdition1249013perdition
permeation14410563permeation
peroration12316003peroration
pervasion1446073pervasion
petition10711753peti_tion
predation12313463predation
privation14311173_privation
purgation1247393purgation
radiation10313393radiation
ration64226013__r_ation
recitation12315943recitation
recreation12413613recreation
reflation12412333reflation
relation82619773re_lation
reliction11310693reliction
reradiation12410153reradiation
reservation1489143reservation
restation9316913restation
salivation1349813salivation
saltation9312003saltation
salvation1239293salvation
sanitation10412043sanitation
satiations10312113satiations
scalation11311073scalation
secretion11118303secretion
section92515663se__ction
sedations10311253se_dations
seditions1039013sedi_tions
seduction1266983seduction
segregation1346383segregation
selection11311273selection
sensations1059853sensations
separation12510433separation
serialise9912143serialise
serialism11811983serialism
serialist9715113serialist
serialize18812633serialize
seriate73722473seriat__e
seriated92717023seriat_ed
seriately1246023seriately
seriates82620673seriat_es
sericin9312843seri_ci_n
serrating10513213serrating
sibilation12128773sibilation
siltation939213siltation
sinuation9310413sinuation
situation949423situation
solation8916153s_olation
solvation1237773solvation
sonication12411183sonication
sorption1037513sor_ption
sortition946703sortition
speciations1548483speciations
spoliation1248423spoliation
starvation1345493starvation
station72717243s__tation
stiction1038823s_tiction
striating10914193striating
strictions1249143strictions
suberization2359243suberization
sublation11311013sublation
sudation9310803s_udation
sulcation11710733sulcation
sulfation1288783sulfation
summation1347803summation
supernation13411663supernation
supination1249883supination
tarnation9310093tarnation
termination131311163termination
urination9312173_urination
usurpation1243813usurpation
variations13310773variations
venation11513503ve_nation
vernations13310333vernations
vexation1838783ve_xation
vitiation1239563vitiation

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411788.25018017.1
3Display Results1781780.0931914.0
 (SQL Overall)1786911788.76620384.6
 
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.