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

113 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
photooxidations2872741photooxidations_
photooxidation2783202photooxidation__
photooxidative3072384photooxidati__ve
autoxidations2153555_aut_oxidations_
photoexcitation29102145photoexcitation__
photoionization2973465photoionization__
photooxidizes3562585photooxid__izes_
photooxidizing3772085photooxidizi_n_g
autoxidation2053786_aut_oxidation__
consolidations1754746_consolidations_
deoxidations2145246___deoxidations_
detoxications2355656_det_oxications_
epoxidations2243646___epoxidations_
ghettoizations2751966ghetto_izations_
intoxications22135686_int_oxications_
motorizations2449126_mot_orizations_
oxidations1845446_____oxidations_
patronizations2576196p_atronizations_
photoemissions2162476photoemi_ssions_
photoinductions23102746photoinductions_
photooxidize3462766photooxid__i__ze
photooxidized3662056photooxid__i_zed
photoreactions21113566phot_oreactions_
photoreceptions2473356photoreceptions_
photoreductions23153346photoreductions_
phototoxicities2973216phototoxiciti_es_
podsolizations26164376p_odsolizations_
podzolizations25153876p_odzolizations_
potentiations1555186p_otenti_ations_
protonations1449076prot_o__nations_
reoxidations2046046___reoxidations_
approximations2761967_approximations_
atomizations2348477__at_omizations_
authorizations2655097_authorizations_
chlorinations1855537ch__lorinations_
colonisations15216177_co_lonisations_
colonizations24229427_co_lonizations_
colorizations241410357_co_lorizations_
consociations1747517_consoci_ations_
consolidation1655157_consolidation__
coordinations1684997_co_ordinations_
deodorizations2556327deo_dorizations_
deoxidation2045957___deoxidation__
detoxication2246207_det_oxication__
epoxidation2144067___epoxidation__
eroticizations25115787erot_icizations_
erotizations21411007erot___izations_
factorizations2855767fact_orizations_
fictionizations2953497fictionizations_
fluoridations1783227__fluoridations_
ghettoization2652187ghetto_ization__
harmonizations28124837_harmonizations_
hominizations2767467_ho_minizations_
homogenisations21192637_homogenisations_
homogenizations30153957_homogenizations_
homologations19102357_ho_mologations_
hydroxylations3163127_hydroxylations_
intimidations1686667_int_imidations_
intoxication21156357_int_oxication__
monopolizations2893397_monopolizations_
motivations1647097_mot___ivations_
motorization2349707_mot_orization__
notarizations2248807_not_arizations_
notifications1848237_not_ifications_
oxidation1746327_____oxidation__
ozonizations2045317__o_zonizations_
participations2054537part_icipations_
pasteurizations2674007pasteurizations_
patinations13411007p_at___inations_
patronization2456757p_atronization__
pectinations1649257pect___inations_
periodizations2655577p_eriodizations_
petrifications2148027p_etrifications_
phonations1538317ph___o__nations_
photoelectrons2173377phot_oelectrons_
photoemission2062847photoemi_ssion__
photoinduction22103007photoinduction__
photoproduction2573067photoproduction__
photoreaction20134177phot_oreaction__
photoreception2373787photoreception__
photoreduction2283717photoreduction__
photostating18135847phot_o_stati_n_g
phytotoxicities3272277phytotoxiciti_es_
picturizations2764687pict_urizations_
pixilations2045337p____ixilations_
podsolization25165007p_odsolization__
podzolization24194377p_odzolization__
polarizations24219717p_o_larizations_
pollinations1447237p___ollinations_
pontifications2187927p_ontifications_
postpositions1753967postposi__tions_
potations111615077p_ot_____ations_
potentiation1455977p_otenti_ation__
predominations19105547p_redominations_
prenominations18105767p_renominations_
preordinations1765717p_reordinations_
preterminations1954307preterminations_
prettifications22135187prettifications_
prolongations1673357pro_lo_ngations_
pronunciations18122787pronunci_ations_
propitiations1756207pro_piti_ations_
propositions16108317pro_posi__tions_
prorogations1556727pro_ro__gations_
protestations1555817prot__estations_
protonation13510437prot_o__nation__
provocations1956877pro_vo__cations_
ratiocinations1674137_ratiocinations_
reoxidation1946657___reoxidation__
rhythmizations3461727rhyt_hmizations_
robotizations2446357_ro_botizations_
strobilations1553887__strobilations_
theorizations2576167th__eorizations_
trepidations1554937___trepidations_

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.360496363.9
2DLD Change Limit950241137.95311948.2
3Display Results1131130.0961177.1
 (SQL Overall)1786911138.40921250.0
 
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.