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 “asseverations” with Change Limit: [1] [2] [3] [4] [5]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

243 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
asseverations165259(None) 
asseveration1552891asseveration_
asseverating1652272asseverati_ng
accelerations1754193accelerations
assentations1245833asse_ntations
assertions1046583ass__er_tions
asseverates1452643asseverat__es
asseverative1852323asseverati_ve
perseverations1953243perseverations
aberrations1346694a_be_rrations
acceleration1654814acceleration_
adulterations1453174adulterations
aerations9317904a____erations
alleviations1554494allev_iations
alliterations1384554alliterations
alterations11511664a__lterations
aspirations1348994a_s_pirations
assentation1146184asse_ntation_
assertion946724ass__er_tion_
asseverate1352694asseverat___e
asseverated1552144asseverat__ed
assignations1344164ass_ignations
assimilations1555204assimilations
associations1445754ass_ociations
cogenerations1655914cogenerations
deaerations12311674__deaerations
decelerations1646424decelerations
degenerations1546354degenerations
desecrations1559214dese_crations
desiderations1545674desiderations
desperations1559524des_perations
federations1548884__federations
generations12311424__generations
intenerations1347464intenerations
passivations1764434passiv__ations
perseveration1853804perseveration_
regenerations1447144regenerations
revelations14410304__revelations
separations1369274__separations
serrations10313104__se_rrations
venerations14411314__venerations
abbreviations202145025abbrev_iations
aberration1267205a_be_rration_
abjurations2045145a__bjurations
abnegations1444925a__bnegations
absorptions1544595abs__orptions
abstentions1364365abs_te_ntions
abstractions1645785abs__tractions
accelerating1753735accelerati_ng
accelerators1682945accelerat_ors
accentuations1753095accentuations
acceptations1864505acce_ptations
acetylations1743545a_cetylations
activations1669265activ__ations
adjurations1944825a__djurations
admirations1446695a__dmirations
adorations11310235a___dorations
adsorptions1444165ads__orptions
adulteration1353665adulteration_
adumbrations1752295a_dumbrations
advections1645555a__dve_ctions
advocations1755415a__dvocations
aeration8319935a____eration_
aestivations1547485aes_tivations
affectations2043435affe_ctations
agglomerations1861785agglomerations
aggregations1553845a_ggregations
alienations1147885a__lienations
allegations1246045a__llegations
alleviation1454655allev_iation_
alliteration1285165alliteration_
alteration10612905a__lteration_
altercations1446375alte_rcations
alternations1246775alte_rnations
ambiversions1961505ambiver_sions
ameliorations1563195ameliorations
annexations1844265a__nnexations
anteverting1544335antever_ti_ng
appellations1643535appe_llations
arbitrations1445765a_rbitrations
ascertains1244265a_s_certai_ns
asperating1349565a_s_perati_ng
aspersions1246105a_s_per_sions
asphyxiations2861335asphyxiations
aspiration1249995a_s_piration_
assassinations13102045assassinations
asserting1038665ass__er_ti_ng
assertors965975ass__er_t_ors
assignation1244375ass_ignation_
assimilation1455525assimilation_
association1346155ass_ociation_
assumptions1562735ass__umptions
attenuations1243805atte_nuations
attestations1244465atte_stations
auscultations1553055auscultations
aversions1247055a___ver_sions
aviations12311555a___v_iations
avocations15168685a___vocations
botherations1754195_botherations
caseations1258305cas__e_ations
cassations1276875cass____ations
castrations13410055cas__trations
celebrations1645745cele_brations
cerebrations1646965cere_brations
cogeneration1546445cogeneration_
confederations20104605confederations
consecrations1749215conse_crations
considerations1764845considerations
conversations1847455_conversations
cooperations1659195_cooperations
crenelations1446185_crenelations
deaeration11313015__deaeration_
deceleration1547175deceleration_
decerebrations1993745decerebrations
decorations14312885__decorations
defecations1779005__defecations
degeneration1447285degeneration_
delegations1348035__delegations
deliberations1645535deliberations
denegations1348545__denegations
denervations1657095__denervations
desecration14410075dese_cration_
desegregations1763565desegregations
desertions1139885__deser_tions
desideration1456395desideration_
desperation14510115des_peration_
deuterations1348085_deuterations
deviations14311165__dev_iations
disrelations1348505dis_relations
disseminations1755085disseminations
dissertations1465895disse_rtations
elevations1338635___elevations
enervations1478575___enervations
enumerations14135515_enumerations
estivations1449275estiv__ations
evections142510695___eve_ctions
eversions1238365___ever_sions
eviscerations1882705eviscerations
evocations15259875___evocations
exaggerations2253485exaggerations
exasperations2253695exasperations
execrations2048925_exe_crations
exenterations2054485exenterations
exertions1639765___exer_tions
exonerations1947015_exonerations
exsertions1746745exs__er_tions
federation1449575__federation_
fenestrations1695405fenestrations
generation11312425__generation_
hebetations1656465__hebetations
immoderations1853075immoderations
impetrations1645445impe_trations
incinerations1545685incinerations
inseminations1546245inseminations
insertions10410345ins__er_tions
inspirations1447305ins_pirations
instaurations13114255instaurations
integrations13129475inte_grations
inteneration1248625inteneration_
iterations10413825___iterations
itinerations1245685_itinerations
lacerations1348335__lacerations
levigations1546215__levigations
levitations1448295__levitations
liberations1358945__liberations
literations11610585__literations
lustrations1147625lus__trations
macerations1548475__macerations
malversations1852565_malversations
miscegenations1963025miscegenations
miscreations1647065miscre_ations
miseducations18113295miseducations
misevaluations19133455misevaluations
moderations1448275__moderations
numerations13127295__numerations
obliterations1553455obliterations
obscurations1644025obs_curations
observations1785015obse_rvations
operations12312955___operations
ossifications18176145ossifications
ostentations1246125oste_ntations
overactions1648215___overactions
passivation16104745passiv__ation_
penetrations1448855pene_trations
perorations13314065__perorations
perseverating1952525perseverati_ng
preparations1648315_preparations
preservations1895545_preservations
preventions1648535_preve_ntions
reassertions1253645reass__er_tions
recreations13412255__recreations
recuperations1746085recuperations
redecorations1645085redecorations
regeneration1348195regeneration_
reiterations12410875_reiterations
rejuvenations23122695rejuvenations
relegations1248975__relegations
remunerations1556205remunerations
reoperations14410065_reoperations
reparations13611665__reparations
resegregations1653695resegregations
reservations1588585rese_rvations
respirations14410305res_pirations
restorations12410955res_torations
revegetations17114715revegetations
revelation13410925__revelation_
reverberations19113585reverberations
reversions1347575__rever_sions
revocations16410315__revocations
salivations1448735saliv__ations
salvations1338135_salv__ations
saturations1148575__saturations
scatterations1552545scatterations
secretions12117855__se_cretions
sedations10311255__s__edations
segregations1445805_segregations
selections12310875__sele_ctions
sensations1059855__se_nsations
separation12510435__separation_
seriations10316685__se_riations
serration9414075__se_rration_
severalties1453665__severalti_es
severities1348515__severiti_es
solvations1336835_solv__ations
speciations1548485_spe_ciations
speculations1646395_speculations
subgenerations1752515subgenerations
subventions1674845_subve_ntions
subversions1654495_subver_sions
supernations14410875__supernations
suppurations1645205_suppurations
suspirations1445855_suspirations
susurrations1244335_susurrations
tessellations1352645tesse_llations
tolerations1158135__tolerations
ulcerations1346365__ulcerations
vegetations1547325__vegetations
venations12311725____venations
veneration13412345__veneration_
vernations13310335____vernations
vexations1937755____vexations
vituperations1852315vituperations
vociferations2153115vociferations

Search took 10 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 Filter1786911247900.393454684.5
2DLD Change Limit1247902438.95313938.3
3Display Results2432430.1531588.2
 (SQL Overall)1786912439.49918811.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.