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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
territorialized2512226(None) 
territorialize23132471territorialize_
territorializes24122371territorializes
editorialized2453553_e_ditorialized
territorialism1662893territoriali_sm
territorialisms1772733territorialisms
territorialist1472773territoriali_st
territorialists1572183territorialists
territoriality1771923territoriali_ty
editorialize2253904_e_ditorialize_
editorializer2372974_e_ditorializer
editorializes2353774_e_ditorializes
territorial1154974territorial____
territorially1662964territorial__ly
territorials1253444territorial___s
dematerialized27144465de_materialized
editorializers24101845_e_ditorializers
memorialized2655305me___morialized
pictorialized2753025__pictorialized
rematerialized26154405re_materialized
temporalized2654265te__mpor_alized
territories1146025territor___i_es
terrorized2075705terr__or___ized
trivialized2484795t__ri__vialized
bestialized2346056be__st__ialized
centralized2348156ce__nt_r_alized
decentralized26144596decent_r_alized
decriminalized2982796decri_minalized
deformalized2874576de___formalized
dematerialize25154916de_materialize_
dematerializes26134826de_materializes
demineralized2694076de_miner_alized
demoralized2457856de___mor_alized
denationalized25124966denatio_nalized
denaturalized2453786de_natur_alized
detribalized2554236detri___balized
devitalized25106976de_vit___alized
editorialist1364656_e_ditoriali_st
editorialists1463416_e_ditorialists
editorializing2563336_e_ditorializing
emotionalized2553836_emotio_nalized
epithelialized29142146_e_pithelialized
eternalized21117336_e___ternalized
externalized2955196_e__xternalized
exterritorial2062106exterritorial____
fertilized2346546fe_r_t__i_lized
immaterialized2893076_immaterialized
industrialized2562906indust_rialized
initialized21125896__init__ialized
literalized2147076___liter_alized
materialized2446556___materialized
memorialised1753946me___morialised
memorialize2456386me___morialize_
memorializes2556006me___morializes
neutralized21117036ne__ut_r_alized
personalized2455876pe_r_so_nalized
pictorialize2553586__pictorialize_
pictorializes2653456__pictorializes
presterilized2563176_presteri_lized
prioritized2353106__pri_ori_tized
rationalized22198036__ratio_nalized
regionalized2355246re_gi_o_nalized
rematerialize24144886re_materialize_
rematerializes25144696re_materializes
renationalized2495266renatio_nalized
resocialized24105196___resocialized
revitalized24117586re_vit___alized
ritualized2046566___rit__ualized
sectarianized2562296se__ctarianized
serialized20810696se_____rialized
spiritualized2563186spirit__ualized
structuralized2691816structur_alized
temporalize2454956te__mpor_alize_
temporalizes2554766te__mpor_alizes
terrorised1184846terr__or___ised
terrorize1887086terr__or___ize_
terrorizes1987066terr__or___izes
theatricalized2961776t_heat_ricalized
traditionalized26102776traditionalized
trivialised1563516t__ri__vialised
trivialize2285636t__ri__vialize_
trivializes2385326t__ri__vializes
tropicalized2653336t__r__opicalized

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.376475242.0
2DLD Change Limit95024838.22011560.1
3Display Results83830.0601383.3
 (SQL Overall)178691838.65620643.6
 
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.