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

220 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
erasions831098(None) 
erasion7311961erasion_
erosions8310341erosions
evasions1136541evasions
abrasions1145812abrasions
aerations9317902aerations
basions94213952_basions
derisions1038842derisions
elations83719122elations
elisions82210422elisions
elusions82610082elusions
enations83316902enations
erasing8317962erasi_ng
erosion7311112erosion_
evasion1036752evasion_
nasions73112382_nasions
orations81515802orations
pervasions1545662pervasions
rations74123432_rations
reasons72514942reas_ons
suasions838782suasions
versions11310352ver_sions
abrasion1046623abrasion_
acrasins1039973acrasi_ns
aeration8319933aeration_
alations82518893alations
anions64123033__anions
arsons63917213ar_s_ons
aversions1247053aver_sions
avions94114393__avions
axions134713483__axions
basins85722763_basi_ns
basion84315853_basion_
bastions10411693_bastions
bradoons1136763bradoons
brains85125473bra_i_ns
brasiers103710513brasiers
brasilins1146243brasilins
brasils9410973brasi_ls
camions113916133_camions
carrions10312453carrions
casinos93512833_casinos
cations94524143_cations
ceratins102818733cerati_ns
cessions1039853cessions
clarions10310493clarions
classons1037703classons
corrasions1246353corrasions
crampons1436643crampons
crasis85020473crasi__s
cratons94316033cra_tons
crayons12439233cra_yons
creations112614543creations
decisions1248383decisions
delations102616593delations
delusions1037053delusions
deraigns1034883dera_igns
derision939073derision_
detrusions1144213detrusions
dragons938383dra_gons
dragoons1045013dragoons
drains73719403dra_i_ns
durations10311463durations
earshots1146623earshots
earstone848603earstone
earstones948523earstones
easies64126633e_asi_es
easing74926463e_asi_ng
eclosions1146203eclosions
edacious1146023edacious
editions9310403editions
effusions1544373effusions
eftsoons1142613eftsoons
egestions1046703egestions
egressions1146203egressions
elains64919853ela_i_ns
elastins82111743elastins
elation73620453elation_
elision72311103elision_
elusion72310953elusion_
elutions82513053elutions
emersions1147283emersions
emissions1146923emissions
emotions10610283emotions
emulsions1145343emulsions
enation73419233enation_
ensigns836353e_nsigns
envisions1245613envisions
eosins64419163e_osi_ns
epsilons1044223e_psilons
equations1839493equations
erasers74413943eras_ers
erases64425403eras__es
erasures837213erasures
erections112515213erections
erepsins1037443erepsi_ns
erosional946623erosional
eruptions1146763eruptions
essoins737603e_ssoins
etalons739073eta_lons
etamins91511833etami_ns
etesians845473etesians
ethions1038483e_thions
evasional1244293evasional
eversions1238363eversions
evulsions1254573evulsions
exactions1838923exactions
excisions1846383excisions
expansions1944153expansions
extrusions1745163extrusions
fanions103713073_fanions
fashions1437243_fashions
fermions1336203fer_mions
fetations12511383fetations
fissions1138033fissions
fractions1449103fractions
frissons1145043frissons
fusions1039153_fusions
gabions102410053_gabions
gascons10289103_gascons
gelations102513093gelations
geraniols1044743geraniols
gracious1138593gracious
gradins93416233gradi_ns
grains74223093gra_i_ns
gratins84119183grati_ns
gravitons1343963gravitons
grisons838993gris_ons
grunions945353grunions
gyrations1336923gyrations
invasions12115413invasions
iterations10413823iterations
kations114013663_kations
keratins122313483kerati_ns
legations102711923legations
lesions73813873_lesions
liaisons844293liaisons
mansions1069793mansions
mascons113411583_mascons
masons83916513_mas_ons
missions10311903missions
nasion63914083_nasion_
nations74720563_nations
negations102811963negations
nervations1359483nervations
occasions1344063occasions
operations12312953operations
oration71617713oration_
orisons7310563oris_ons
ovations11149263ovations
parsons93516873pars_ons
passions10310583passions
pensions10311693pensions
pereions10310853per_eions
perfusions1595333perfusions
persons93717013per_s_ons
persuasions1383913persuasions
pervasion1446073pervasion_
plasmons12217663plasmons
plosions1038023plosions
prions84317783pr__ions
prisons9313223pris_ons
pulsions1037713pulsions
racons84319343_ra_cons
racoons93912433_racoons
radians83013823_radians
radios74018673_radio_s
radons74118533_ra_dons
rains55140233_ra_i_ns
raisins72715343_raisins
rampions12248023_rampions
ramsons939563_ramsons
rasing74330833_rasi_ng
ration64226013_ration_
ratios64922673_ratio_s
ratoons73815473_ratoons
rattons73815323_rattons
ravins94622563_ravi_ns
rawins95617623_rawi_ns
rayons94113343_ra_yons
reactions11711713reactions
reagins84215643reagi_ns
realigns936253realigns
reason62616333reas_on_
reassigns1074353reassigns
recisions1139913recisions
refashions1643063refashions
regions83613473_regions
relations92418333relations
resigns83910963_resigns
resins64528773_resi_ns
reunions837273reunions
revisions1238593revisions
ronions73313343_ronions
rosins64521863_rosi_ns
sasins64923103_sasi_ns
scansions1145323scansions
seasons72614233seas_ons
sedations10311253sedations
seriations10316683seriations
serrations10313103serrations
sessions839723sessions
stations82415223stations
suasion739363suasion_
talions7314113_talions
tensions8310223tensions
ternions838813ter_nions
torsions839183torsions
tractions11511623tractions
trains64725343tra_i_ns
treasons848683treas_ons
venations12311723venations
veracious1447123veracious
vernations13310333vernations
version10310923ver_sion_
vexations1937753vexations
visions10311023_visions
wanions104011373_wanions
warisons1136903warisons
weasons102310583weas_ons

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 Filter1786911461620.453394461.4
2DLD Change Limit1461622206.67321903.5
3Display Results2202200.0932365.6
 (SQL Overall)1786912207.21924752.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.