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

116 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
fictionizations295350(None) 
fictionization2863601fictionization_
factorizations2855763fact_orizations
missionizations26103573missionizations
victimizations3064283victi_mizations
canonizations2447244__canonizations
cocainizations2755434cocai_nizations
colonizations24229424__colonizations
decolonizations27145964decolonizations
deionizations2349214__deionizations
factorization2756284fact_orization_
feminizations2797714f_emi_nizations
fertilizations26137894ferti_lizations
fictionizing2753804fictioniz__i_ng
fractionations1952864fraction__ations
fraternizations27153754fraternizations
ionizations2049894____ionizations
latinizations22159014_lati_nizations
lionizations2147124___lionizations
missionization2593644missionization_
patronizations2576194_patronizations
picturizations2764684pict_urizations
pidginizations2763614pidgi_nizations
recolonizations26165764recolonizations
routinizations2355544routi_nizations
unionizations2255314__unionizations
victimization2984594victi_mization_
actualizations25126965_actualizations
atomizations2348475__at_omizations
authorizations2655095_authorizations
bacterizations2766675bact_erizations
bituminizations2882525bituminizations
canonization2347925__canonization_
carbonizations2774955_carbonizations
cicatrizations2794915cic_atrizations
citifications2048545ci_ti_fications
civilizations2747275ci_vi_lizations
cocainization2655955cocai_nization_
colonisations15216175__colonisations
colonization232010235__colonization_
colorizations241410355__colorizations
creolizations2457885__creolizations
decolonization26146025decolonization_
decolorizations27136105decolorizations
deionization2249885__deionization_
demonizations25410245__demonizations
diazotizations2353685di_azotizations
digitalizations2686185digitalizations
digitizations2447085di_gi_tizations
eroticizations25115785eroti_cizations
eternizations2258075__eternizations
facilitations1845765fac_i_litations
feminization26128485f_emi_nization_
fertilization2588455ferti_lization_
fiberizations27136375fi__berizations
fictionalises1855845fiction__alises
fictionalities1963645fictionaliti_es
fictionalizes2774895fiction__alizes
fictionists1655995fictioni_st___s
fictionizes2554115fictioniz____es
finalizations2549255fi__nalizations
fluidizations2663415f_lui_dizations
focalizations2748995foc__alizations
fortifications2286215forti_fications
fossilizations2654685fossi_lizations
fractionation1853205fraction__ation_
fraternization26174065fraternization_
fructifications25113355fructi_fications
gelatinizations2554085gelati_nizations
ghettoizations2751965ghetto_izations
harmonizations28124835_harmonizations
hominizations2767465_homi_nizations
idolizations2247465_i__dolizations
immunizations26115345_i_mmunizations
indigenizations2662335_indigenizations
initializations2475505initializations
intimidations1686665_inti_midations
intonations1149525_int_on__ations
intoxications22135685_int_oxications
ionization19411275____ionization_
itemizations2347845_i_t_emizations
itinerations1245685_i_ti_nerations
keratinizations2853865kerati_nizations
laciniations1445915lac_i_ni_ations
latinization21139525_lati_nization_
lionization2047885___lionization_
luteinizations2355065_luteinizations
mechanizations3055815mec_hanizations
militarizations2654945militarizations
minimizations26136555mi_ni_mizations
misutilizations26145155misuti_lizations
motorizations2449125_mot_orizations
optimizations26155715_opti_mizations
ozonizations2045315___ozonizations
patronization2456765_patronization_
pectinations1649255pecti_n__ations
periodizations2655575_periodizations
photoionization2973465photoionization_
picturization2674985pict_urization_
pidginization2653925pidgi_nization_
ratiocinations1674145_ratiocinations
recolonization25155885recolonization_
rectifications2148915recti_fications
reutilizations2348715reuti_lizations
ritualizations2357985ri_tualizations
routinization2255835routi_nization_
salinizations2258425_sali_nizations
socializations2548485soc_ializations
subtilizations2556065subti_lizations
tetanizations2249915_tet_anizations
unionisations1353205__unionisations
unionization2156035__unionization_
utilizations2148895__uti_lizations
vitalizations25410325vi_t_alizations
westernizations27154135westernizations
winterizations26157505wint_erizations

Search took 5 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 Filter178691658740.330541487.9
2DLD Change Limit658741164.15615850.3
3Display Results1161160.0931247.3
 (SQL Overall)1786911164.57939024.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.