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

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

227 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
administrations1816241(None) 
administration17142551administration_
administrating1862132administrati_ng
administrators1761712administrat_ors
ministrations1555452__ministrations
administrates1662393administrat__es
administrative2072153administrati_ve
administrator1661973administrat_o_r
ministration1465833__ministration_
administrant1562484administra___nt
administrants1662074administra__nts
administrate1562534administrat___e
administrated1762064administrat__ed
administratrix2481284administrat_rix
admirations1446694adm__i__rations
demonstrations1795674demon_strations
remonstrations16116494remon_strations
administering1762195administ_eri_ng
administrable1871605administra__ble
admiration1347735adm__i__ration_
admonitions1444245admoni____tions
ameliorations1563195a_meli_orations
ammoniations1645415ammoni___ations
ammonifications2453045ammonifications
arbitrations1445775a__rbi_trations
commiserations2053455com_miserations
defenestrations1993305defenestrations
demonstration16126285demon_stration_
denigrations1447355_d_eni_grations
distractions1548765_d___istractions
feminizations2797715femini__zations
fenestrations1695405__fenestrations
hominizations2767465homini__zations
infiltrations1653905___infiltrations
initiations11410725___ini_tiations
menstruations1585055__men_struations
mensurations1445715__men_surations
minimizations26136555__minimizations
nitrations10312035____ni_trations
registrations1446905__registrations
remonstration15117125remon_stration_
reregistrations1672825reregistrations
abominations1646616abomin____ations
abstractions1645796a____bstractions
accentuations1753096accen__tuations
acidifications2254636a_cidifications
adaptations1464576ad___apt_ations
adjudications2452326adjudi__cations
adjurations1944826ad____jurations
administers1452906adminis___t_ers
admissions1343466adm__is___sions
admonition1344446admoni____tion_
adnations1039756ad__n____ations
adorations11310246ad_____orations
adsorptions1444176ad____sorptions
adulterations1453176ad__ulterations
adumbrations1752296ad___umbrations
affiliations1844186affili___ations
afforestations2062246afforest_ations
agitations11310066a___gi_t_ations
alimentations1594996a_liment_ations
alliterations1384566a__lliterations
amelioration1464016a_meli_oration_
ammoniation1545906ammoni___ation_
ammonification2353046ammonification_
ammunitions15113656ammuni____tions
amplifications2384756a_mplifications
amputations1546446a_m__put_ations
animations12312196a___ni__mations
annihilations1653996a__nnihilations
annotations1146886a___nnot_ations
anticipations1757496antici__pations
arbitration1346476a__rbi_tration_
aspirations1348996a__spi__rations
assentations1245846assen__t_ations
assimilations1555206assimi__lations
attestations1244466a__ttest_ations
augmentations1654126augmen__t_ations
castrations13410076____castrations
cementations1659016cemen__t_ations
civilisations1853646civilis__ations
colonisations15216176colonis__ations
commensurations21182586commensurations
commiseration1964046com_miseration_
damnations1337086dam_n____ations
debilitations1647136debili_t_ations
defenestration18173546defenestration_
degustations1444836_d_egust_ations
deifications18410656_deifi__cations
deionizations2349216_deioni__zations
deliberations1645536_d_eliberations
delimitations1676636delimi_t_ations
demonizations25410246demoni__zations
demonstrating17104766demon_strati_ng
demonstrational1862636demon_strational
demonstratives2063206demon_stratives
demonstrators1673416demon_strat_ors
denaturations1444956_d_enaturations
denigration1348466_d_eni_gration_
denitrating13128336_d_eni_trati_ng
denotations1239856_d_en_ot_ations
dentations11413636_d_en__t_ations
desiderations1545676_d_esiderations
detestations1347586_d_etest_ations
devastations1645826_d_evast_ations
dictations1389706_d___ict_ations
digitizations2447086_d_igitizations
dilatations1246416_d_i_lat_ations
discretions1447236_d___iscretions
disinfestations1993506disinfest_ations
disinflations1756296_d_isinflations
disintegrations17153636disintegrations
disputations15106176_d_isput_ations
dissertations1465906_d_i_ssertations
dissipations1546536_d_i_ssipations
distentions12178866_d___istentions
distortions1246626_d___istortions
distraction1449126_d___istraction_
distrains10411346_d___istra_i_ns
divinations15128416_d_ivi__nations
domiciliations1992536domici_liations
dominations14611046domin____ations
dubitations1456676_d_ubi_t_ations
edifications1848696ed_ifi__cations
elicitations1446806_elici_t_ations
emigrations14187156_em__i_grations
equilibrations2561976equili_brations
facilitations1845766facili_t_ations
felicitations1874586felici_t_ations
feminization26128486femini__zation_
fenestration1596076__fenestration_
filtrations1445626____filtrations
fomentations1746796fomen__t_ations
frustrations1544536___frustrations
geminations14139266gemin____ations
habilitations1884866habili_t_ations
harmonizations28124836harmoni__zations
hominization2657996homini__zation_
humanizations2796636humani__zations
humidifications2652816humidifications
humifications2345856humifi__cations
humiliations1784556humili___ations
illustrations1353156__illustrations
imitations1259966___imi_t_ations
immigrations1743726_im_mi_grations
immunizations26115346immuni__zations
impetrations1645446___impetrations
incinerations1545686___incinerations
incitations13310886___incit_ations
indiscretions1652596___indiscretions
indurations1249586___in_durations
infatuations1544436___infatuations
infestations1546626___infest_ations
infiltration1554526___infiltration_
initiation10412106___ini_tiation_
insanitations13136476insani_t_ations
insertions10410346___in_ser_tions
insinuations12136426___insinuations
insolations1149186___in_solations
inspirations1447306___inspirations
instaurations13114256___in_staurations
instigations1348246___in_stigations
instructions14137826___in_structions
insulations11310236___in_sulations
integrations13129476___integrations
invigorations1753916___invigorations
invitations1449056___invit_ations
itinerations1245686___itinerations
laciniations1445916lacini___ations
lamentations1495986lamen__t_ations
laminations1339806lamin____ations
latinizations22159016latini__zations
limitations1348186__limi_t_ations
lustrations1147626____lustrations
manifestations1981866manifest_ations
manipulations1754116__manipulations
meditations1449336__medi_t_ations
meliorations1466756__meli_orations
menstruation1455226__men_struation_
mensuration1346496__men_suration_
mentations12312586__men__t_ations
migrations13168686__m__i_grations
minimization25127196__minimization_
ministates1246746__minist_at__es
ministrant1255816__ministra___nt
ministrants1353866__ministra__nts
ministries1247566__ministr__i_es
miscitations1647056__miscit_ations
miscreations1647066__m__iscreations
misestimations18144426__misestimations
mistrains11511356__m__istra_i_ns
mitigations1447626__miti__gations
modernisations1752726modernis__ations
molestations1475476__molest_ations
nictations1278316____nict_ations
nitration9313446____ni_tration_
nominations13410536nomin____ations
optimisations17153446optimis__ations
orchestrations19113306_orchestrations
organisations1473356organis__ations
penetrations1448856__pen_etrations
pidginizations2763616pidgini__zations
prostrations1449776___prostrations
ramifications2087536ramifi__cations
redintegrations17143256redintegrations
registration1347546__registration_
reinfestations1793886_reinfest_ations
reinsertions1245286_rein_ser_tions
reintegrations15164786_reintegrations
reinvigorations19152416_reinvigorations
remigrations15227796rem__i_grations
remonstrating1695556remon_strati_ng
remonstrators1583566remon_strat_ors
remunerations1556206remun__erations
reregistration1583136reregistration_
romanizations2459296romani__zations
ruminations1349396rumin____ations
salinizations2258426salini__zations
sanitations11410846__sani_t_ations
semiabstraction217676semiabstraction_
sequestrations23182996_sequestrations
solicitations1544896solici_t_ations
titrations1039176____ti_trations
unionisations1353206unionis__ations
urbanisations1552856urbanis__ations
vinifications2177696__vinifications
visitations1447676__visi_t_ations

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 Filter178691950240.373479064.3
2DLD Change Limit950242277.76612235.9
3Display Results2272270.1731312.1
 (SQL Overall)1786912278.31221498.0
 
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.