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

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

228 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
administrations18162411administrations_
administration17142552administration__
administrating1862133administrati_n_g
administrators1761713administrat_ors_
ministrations1555453__ministrations_
administrates1662394administrat__es_
administrative2072154administrati__ve
administrator1661974administrat_o__r
ministration1465834__ministration__
administrant1562485administra___n_t
administrants1662075administra___nts
administrate1562535administrat____e
administrated1762065administrat___ed
administratrix2481285administrat__rix
admirations1446695adm__i__rations_
demonstrations1795675demon_strations_
remonstrations16116495remon_strations_
administering1762196administ_eri_n_g
administrable1871606administra___ble
admiration1347736adm__i__ration__
admonitions1444246admoni____tions_
ameliorations1563196a_meli_orations_
ammoniations1645416ammoni___ations_
ammonifications2453046ammonifications_
arbitrations1445776a__rbi_trations_
commiserations2053456com_miserations_
defenestrations1993306defenestrations_
demonstration16126286demon_stration__
demonstrational1862636demon_strational
denigrations1447356_d_eni_grations_
distractions1548766_d___istractions_
feminizations2797716femini__zations_
fenestrations1695406__fenestrations_
hominizations2767466homini__zations_
infiltrations1653906___infiltrations_
initiations11410726___ini_tiations_
menstruations1585056__men_struations_
mensurations1445716__men_surations_
minimizations26136556__minimizations_
nitrations10312036____ni_trations_
registrations1446906__registrations_
remonstration15117126remon_stration__
reregistrations1672826reregistrations_
abominations1646617abomin____ations_
abstractions1645797a____bstractions_
accentuations1753097accen__tuations_
acidifications2254637a_cidifications_
adaptations1464577ad___apt_ations_
adjudications2452327adjudi__cations_
adjurations1944827ad____jurations_
administers1452907adminis___t_ers_
admissions1343467adm__is___sions_
admonition1344447admoni____tion__
adnations1039757ad__n____ations_
adorations11310247ad_____orations_
adsorptions1444177ad____sorptions_
adulterations1453177ad__ulterations_
adumbrations1752297ad___umbrations_
affiliations1844187affili___ations_
afforestations2062247afforest_ations_
agitations11310067a___gi_t_ations_
alimentations1594997a_liment_ations_
alliterations1384567a__lliterations_
amelioration1464017a_meli_oration__
ammoniation1545907ammoni___ation__
ammonification2353047ammonification__
ammunitions15113657ammuni____tions_
amplifications2384757a_mplifications_
amputations1546447a_m__put_ations_
animations12312197a___ni__mations_
annihilations1653997a__nnihilations_
annotations1146887a___nnot_ations_
anticipations1757497antici__pations_
arbitration1346477a__rbi_tration__
arbitrational1553187a__rbi_trational
aspirations1348997a__spi__rations_
assentations1245847assen__t_ations_
assimilations1555207assimi__lations_
attestations1244467a__ttest_ations_
augmentations1654127augmen__t_ations_
castrations13410077____castrations_
cementations1659017cemen__t_ations_
civilisations1853647civilis__ations_
colonisations15216177colonis__ations_
commensurations21182587commensurations_
commiseration1964047com_miseration__
damnations1337087dam_n____ations_
debilitations1647137debili_t_ations_
defenestration18173547defenestration__
degustations1444837_d_egust_ations_
deifications18410657_deifi__cations_
deionizations2349217_deioni__zations_
deliberations1645537_d_eliberations_
delimitations1676637delimi_t_ations_
demonizations25410247demoni__zations_
demonstrating17104767demon_strati_n_g
demonstratives2063207demon_stratives_
demonstrators1673417demon_strat_ors_
denaturations1444957_d_enaturations_
denigration1348467_d_eni_gration__
denitrating13128337_d_eni_trati_n_g
denotations1239857_d_en_ot_ations_
dentations11413637_d_en__t_ations_
desiderations1545677_d_esiderations_
detestations1347587_d_etest_ations_
devastations1645827_d_evast_ations_
dictations1389707_d___ict_ations_
digitizations2447087_d_igitizations_
dilatations1246417_d_i_lat_ations_
discretions1447237_d___iscretions_
disinfestations1993507disinfest_ations_
disinflations1756297_d_isinflations_
disintegrations17153637disintegrations_
disputations15106177_d_isput_ations_
dissertations1465907_d_i_ssertations_
dissipations1546537_d_i_ssipations_
distentions12178867_d___istentions_
distortions1246627_d___istortions_
distraction1449127_d___istraction__
distrains10411347_d___istra_i_ns_
divinations15128417_d_ivi__nations_
domiciliations1992537domici_liations_
dominations14611047domin____ations_
dubitations1456677_d_ubi_t_ations_
edifications1848697ed_ifi__cations_
elicitations1446807_elici_t_ations_
emigrations14187157_em__i_grations_
equilibrations2561977equili_brations_
facilitations1845767facili_t_ations_
felicitations1874587felici_t_ations_
feminization26128487femini__zation__
fenestration1596077__fenestration__
filtrations1445627____filtrations_
fomentations1746797fomen__t_ations_
frustrations1544537___frustrations_
geminations14139267gemin____ations_
habilitations1884867habili_t_ations_
harmonizations28124837harmoni__zations_
hominization2657997homini__zation__
humanizations2796637humani__zations_
humidifications2652817humidifications_
humifications2345857humifi__cations_
humiliations1784557humili___ations_
illustrations1353157__illustrations_
imitations1259967___imi_t_ations_
immigrations1743727_im_mi_grations_
immunizations26115347immuni__zations_
impetrations1645447___impetrations_
incinerations1545687___incinerations_
incitations13310887___incit_ations_
indiscretions1652597___indiscretions_
indurations1249587___in_durations_
infatuations1544437___infatuations_
infestations1546627___infest_ations_
infiltration1554527___infiltration__
initiation10412107___ini_tiation__
insanitations13136477insani_t_ations_
insertions10410347___in_ser_tions_
insinuations12136427___insinuations_
insolations1149187___in_solations_
inspirations1447307___inspirations_
instaurations13114257___in_staurations_
instigations1348247___in_stigations_
instructions14137827___in_structions_
insulations11310237___in_sulations_
integrations13129477___integrations_
invigorations1753917___invigorations_
invitations1449057___invit_ations_
itinerations1245687___itinerations_
laciniations1445917lacini___ations_
lamentations1495987lamen__t_ations_
laminations1339807lamin____ations_
latinizations22159017latini__zations_
limitations1348187__limi_t_ations_
lustrations1147627____lustrations_
manifestations1981867manifest_ations_
manipulations1754117__manipulations_
meditations1449337__medi_t_ations_
meliorations1466757__meli_orations_
menstruation1455227__men_struation__
mensuration1346497__men_suration__
mentations12312587__men__t_ations_
migrations13168687__m__i_grations_
minimization25127197__minimization__
ministates1246747__minist_at__es_
ministrant1255817__ministra___n_t
ministrants1353867__ministra___nts
ministries1247567__ministr__i_es_
miscitations1647057__miscit_ations_
miscreations1647067__m__iscreations_
misestimations18144427__misestimations_
mistrains11511357__m__istra_i_ns_
mitigations1447627__miti__gations_
modernisations1752727modernis__ations_
molestations1475477__molest_ations_
nictations1278317____nict_ations_
nitration9313447____ni_tration__
nominations13410537nomin____ations_
optimisations17153447optimis__ations_
orchestrations19113307_orchestrations_
organisations1473357organis__ations_
penetrations1448857__pen_etrations_
pidginizations2763617pidgini__zations_
prostrations1449777___prostrations_
ramifications2087537ramifi__cations_
redintegrations17143257redintegrations_
registration1347547__registration__
reinfestations1793887_reinfest_ations_
reinsertions1245287_rein_ser_tions_
reintegrations15164787_reintegrations_
reinvigorations19152417_reinvigorations_
remigrations15227797rem__i_grations_
remonstrating1695557remon_strati_n_g
remonstrators1583567remon_strat_ors_
remunerations1556207remun__erations_
reregistration1583137reregistration__
romanizations2459297romani__zations_
ruminations1349397rumin____ations_
salinizations2258427salini__zations_
sanitations11410847__sani_t_ations_
semiabstraction217677semiabstraction__
sequestrations23182997_sequestrations_
solicitations1544897solici_t_ations_
titrations1039177____ti_trations_
unionisations1353207unionis__ations_
urbanisations1552857urbanis__ations_
vinifications2177697__vinifications_
visitations1447677__visi_t_ations_

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 Filter178691950240.360496363.9
2DLD Change Limit950242289.26610255.1
3Display Results2282280.1701341.2
 (SQL Overall)1786912289.79618241.2
 
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.