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

185 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
erosion731112(None) 
erasion7311961erasion
erosions8310341erosions
derision939072derision
eclosion1046902eclosion
elision72311102elision
elusion72310952elusion
emotion9711302emotion
eosin55220922e_osi_n
erasions8310982erasions
erosional946622erosional
erosive1039202erosive
evasion1036752evasion
plosion939112plosion
ronion63315642_ronion
rosin55325312_rosi_n
torsion7310802torsion
version10310922ver_sion
abrasion1046623abrasion
acromion1246063acromion
aeration8319933aeration
aerosol747683aeros_ol
amotion9710473amotion
arsino64113513ar_sino
arson55118833ar_s_on
aversion1147313aver_sion
basion84315853_basion
boson76019733_bos_on
boston8513043_boston
bromin102615693bromi_n
cession939813cession
chorion12311773chorion
corrosion1146053corrosion
cosign958783_cosign
croon75522783cro__on
crosier94116583crosier
crostino1038883crostino
croton84415453cro_ton
crouton947133crouton
decision1148523decision
delusion937433delusion
demotion1169073demotion
derisions1038843derisions
detrusion1044383detrusion
devotion1256763devotion
dromon939363dro_mon
eclosions1146203eclosions
edition8310853edition
effusion1444613effusion
eftsoon1043253eftsoon
egestion946863egestion
egression1046193egression
elation73620453elation
elisions82210423elisions
eloign7456983elo_ign
eloin55923203elo_i_n
elusions82610083elusions
elution72913823elution
elysian1065083elysian
emersion1047733emersion
emission1047673emission
emodin9310353emodi_n
emoticon1273793emoticon
emotions10610283emotions
empoison1243843empoison
emulsion1045923emulsion
enation73419233enation
enosis63816423enosi_s
ensign737523e_nsign
entropion11106293entropion
envision1145953envision
eobiont959943e_obiont
eolian6312593e_olian
eonian6311833e_onian
eosine64519413e_osine
eosins64419163e_osins
epsilon944293e_psilon
erasing8317963erasing
erection102115513erection
erepsin937393erepsi_n
eroding9314273eroding
eros45238453eros___
erose55727283eros__e
erosely1038083erosely
eroses65327063eros_es
erosible1046443erosible
erotic82620273eroti_c
erotica92811513erotica
erotics91914153erotics
erotism9312303erotism
erotize16311663erotize
eruption1047043eruption
essoin638193essoi_n
etesian757853etesian
ethion938813e_thion
evasions1136543evasions
eversion1138713eversion
evulsion1155063evulsion
excision1746273excision
explosion18115213explosion
extrusion1645253extrusion
fermion1236763fer_mion
fission1038733fission
foison948933_foison
frisson1045313frisson
fronton1037203fronton
fusion939773_fusion
gonion73612833_gonion
grison7310103gris_on
groin65521083gro_i_n
grunion835433grunion
heroin94420593hero_i_n
kerosine1238153kerosine
kroon94514483kro__on
lesion64715063_lesion
logion76013723_logion
lotion65716523_lotion
mansion9611543mansion
mission9312743mission
morion86217733_morion
morrion959003morrion
motion85217553_motion
myosin113410763myosi_n
nasion63914083_nasion
notion64516583_notion
onion54320973__onion
oration71617713oration
orison6411663oris_on
passion9310883passion
pension9412203pension
pereion9312053per_eion
perfusion14105883perfusion
person83517873per_s_on
pervasion1446073pervasion
plosions1038023plosions
poison8312223_poison
portion9615493portion
potion84519573_potion
prion75119993pr__ion
prison8514023pris_on
profusion1445703profusion
prolusion1146363prolusion
prosier93817493prosier
prosily12611633prosily
prosing103319383prosing
prosit85124593prosi_t
proso77222413pros_o_
prosos85718553pros_os
proton84318893pro_ton
prounion1046823prounion
provision1447633provision
pulsion938393pulsion
ration64226013_ration
reason62616333reas_on
recision10310273recision
region74614903_region
remotion10410233remotion
resign74212583_resign
resin54131053_resi_n
retorsion946503retorsion
reunion737673reunion
revision1138713revision
robin74820283_robi_n
ronions73313343_ronions
ronyon9309133_ronyon
roscoe839763_roscoe
rosier64221273_rosier
rosily93914713_rosily
rosing73925593_rosing
rosinol756323_rosinol
rosins64521863_rosins
rosiny94414533_rosiny
serosity1148793serosity
session739763session
solion6616383_solion
sponsion1045623sponsion
suasion739363suasion
tension7311803tension
ternion739493ter_nion
torsions839183torsions
trogon73611753tro_gon
tropin83316753tropi_n
versions11310353ver_sions
vision9311313_vision
xerosis14249673xerosi_s

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.466383457.1
2DLD Change Limit1340271856.97019229.1
3Display Results1851850.0802312.5
 (SQL Overall)1786911857.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.