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

126 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
fictionization286360(None) 
fictionizations2953491fictionizations
factorization2756283fact_orization
missionization2593643missionization
victimization2984583victi_mization
canonization2347924__canonization
cocainization2655954cocai_nization
colonization232010234__colonization
decolonization26146024decolonization
deionization2249884__deionization
factorizations2855754fact_orizations
feminization26128474f_emi_nization
fertilization2588454ferti_lization
fictionizing2753804fictioniz__ing
fractionation1853204fraction__ation
fraternization26174054fraternization
ionization19411274____ionization
latinization21139524_lati_nization
lionization2047884___lionization
missionizations26103574missionizations
patronization2456744_patronization
photoionization2973454photoionization
picturization2674984pict_urization
pidginization2653924pidgi_nization
recolonization25155884recolonization
routinization2255834routi_nization
unionization2156034__unionization
victimizations3064274victi_mizations
actualization24137465_actualization
atomization2249225__at_omization
authorization2555855_authorization
bacterization26107205bact_erization
bituminization2792575bituminization
canonizations2447245__canonizations
carbonization2675495_carbonization
cicatrization2675415cic_atrization
citification1949155ci_ti_fication
civilianization2971815civilianization
civilization2647615ci_vi_lization
cocainizations2755435cocai_nizations
colonisation14176765__colonisation
colonizations24229425__colonizations
colorization231711195__colorization
creolization2348815__creolization
decolonizations27145965decolonizations
decolorization26136415decolorization
deionizations2349215__deionizations
demonization24410935__demonization
diazotization2264305di_azotization
dichotomization32101825dichotomization
digitalization2586365digitalization
digitization2347685di_gi_tization
eroticization2476035eroti_cization
eternization2158665__eternization
facilitation1746575fac_i_litation
feminizations2797705f_emi_nizations
fertilizations26137895ferti_lizations
fiberization26136715fi__berization
fictionalise1756265fiction__alise
fictionalities1963635fictionalities
fictionality2054615fiction__ality
fictionalize2665125fiction__alize
fictionist1558025fictioni_st___
fictionists1655995fictioni_st__s
fictionize2454205fictioniz____e
fictionized2653365fictioniz___ed
fictionizes2554105fictioniz___es
finalization2459925fi__nalization
fluidization2553605f_lui_dization
focalization2649665foc__alization
fortification2196925forti_fication
fossilization2565145fossi_lization
fractionations1952855fraction__ations
fraternizations27153745fraternizations
fructification2483675fructi_fication
gelatinization2453955gelati_nization
ghettoization2652185ghetto_ization
harmonization27125295_harmonization
hominization2657995_homi_nization
idolization2147765_i__dolization
immunization25115905_i_mmunization
indigenization2562625_indigenization
initialization2395955initialization
interiorization2464785_interiorization
intimidation1547365_inti_midation
intonation10410265_int_on__ation
intoxication21156355_int_oxication
ionizations2049895____ionizations
itemization2248325_i_t_emization
itineration1156325_i_ti_neration
keratinization2754005kerati_nization
laciniation1346635lac_i_ni_ation
latinizations22159015_lati_nizations
lionizations2147125___lionizations
luteinization2255295_luteinization
mechanization2956325mec_hanization
militarization2555025militarization
minimization25127195mi_ni_mization
misutilization25155485misuti_lization
motorization2349695_mot_orization
nationalization24114155_nationalization
optimization25166455_opti_mization
ozonization1945835___ozonization
patronizations2576185_patronizations
pectination15410335pecti_n__ation
periodization2556065_periodization
picturizations2764675pict_urizations
pidginizations2763615pidgi_nizations
ratiocination1574325_ratiocination
rationalization24114555_rationalization
recolonizations26165765recolonizations
rectification2049515recti_fication
reutilization2249195reuti_lization
ritualization2258525ri_tualization
routinizations2355545routi_nizations
salinization2158895_sali_nization
socialization2449095soc_ialization
subtilization2456625subti_lization
synchronization3272155synchronization
tetanization21410285_tet_anization
unionisation1253445__unionisation
unionizations2255315__unionizations
utilization2049685__uti_lization
vitalization24410965vi_t_alization
westernization26134465westernization
winterization25137805wint_erization

Search took 7 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.1261418182.5
2DLD Change Limit950241266.68614212.4
3Display Results1261260.0961312.5
 (SQL Overall)1786911266.90825867.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.