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

114 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
editorialized245355(None) 
editorialize2253901editorialize_
editorializer2372971editorializer
editorializes2353771editorializes
editorializers24101842editorializers
editorialist1364653editoriali_st
editorialists1463413editorialists
editorializing2563333editorializing
pictorialized2753023pictorialized
territorialized25122263territorialized
deformalized2874574_deformalized
dematerialized27144464dematerialized
demoralized2457854_demor_alized
detribalized2554234_det_ribalized
disorganized2452964_disorganized
editorial1047314editorial____
editorially1554264editorial__ly
editorials1144524editorial___s
epithelialized29142144epithelialized
eternalized21117334e__ternalized
externalized2955194e_xternalized
initialized21125894init__ialized
literalized2147074_liter_alized
materialized2446554_materialized
memorialized2655304_memorialized
pictorialize2553584pictorialize_
pictorializes2653454pictorializes
rematerialized26154404rematerialized
territorialize23132474territorialize_
territorializes24122374territorializes
bestialized2346055best__ialized
centralized2348155cent_r_alized
colonialized2453635_colonialized
deformalize2655275_deformalize_
deformalizes2754875_deformalizes
delocalized2445345_delo_calized
dematerialize25154915dematerialize_
dematerializes26134825dematerializes
demineralized2694075deminer_alized
demobilized2654595_demobi_lized
demoralize2269225_demor_alize_
demoralizer2366745_demor_alizer
demoralizes2368435_demor_alizes
denaturalized2453785denatur_alized
desacralized2553925desacr_alized
destabilized2563745destabi_lized
detribalize2355005_det_ribalize_
detribalizes2454555_det_ribalizes
devitalized25106975devit___alized
devocalized2744895_devo_calized
diagonalized24253225_diagonalized
digitalized2345315_di_gitalized
disorganize2253665_disorganize_
disorganizes2353355_disorganizes
emotionalized2553835emotionalized
epithelialize27142515epithelialize_
epithelializes28142315epithelializes
epithelized2653645epit__helized
epitomized2444445epito___mized
essentialized2363265essentialized
eternalize19118505e__ternalize_
eternalizes20118175e__ternalizes
etherealized2553355e_therealized
exteriorized2953195e_xteriorized
externalised2054125e_xternalised
externalize2756385e_xternalize_
externalizes2855815e_xternalizes
federalized2545145fed__er_alized
formalized25268935___formalized
historicized2782245histori_cized
immaterialized2893075immaterialized
immortalized26103495_immortalized
industrialized2562905industrialized
initialize1996865init__ialize_
initializes20126405init__ializes
internalized22147455_internalized
italianized21153435__italianized
lateralized2147405_later_alized
liberalized2345445_liber_alized
literalize1948745_liter_alize_
literalizes2048115_liter_alizes
materialised1555475_materialised
materialize2247895_materialize_
materializer2355365_materializer
materializes2347225_materializes
memorialised1753945_memorialised
memorialize2456385_memorialize_
memorializes2556005_memorializes
mineralized2346655_miner_alized
moralized21310755___mor_alized
nationalized22197345natio_nalized
naturalized2155555_natur_alized
neutralized21117035neut_r_alized
normalized22358825___normalized
outorganized23112545_outorganized
prioritized2353105pri_ori_tized
rationalized22198035ratio_nalized
regionalized2355245regi_o_nalized
rematerialize24144885rematerialize_
rematerializes25144695rematerializes
resocialized24105195_resocialized
revitalized24117585revit___alized
ritualized2046565_rit__ualized
sectarianized2562295sectarianized
serialized20810695___serialized
socialized2247365___socialized
sterilized2046765__steri_lized
temporalized2654265tempor_alized
totalized1949455___to_talized
trivialized2484795tri__vialized
universalized2662525universalized
unsterilized2253515unsteri_lized
virilized2246235_vi__ri_lized
vitalized2239115_vit___alized

Search took 10 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 Filter1786911247900.406440125.6
2DLD Change Limit1247901149.37613309.5
3Display Results1141140.0761500.0
 (SQL Overall)1786911149.85818126.5
 
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.