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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
materializes234722(None) 
materialises1447321materialises
materialize2247891materialize_
materialized2446551materialized
materializer2355361materializer
materializers2453171materializers
dematerializes26134822dematerializes
immaterializes2793362immaterializes
lateralizes2048432later_alizes
materialise1347842materialise_
materialised1555472materialised
materialisms1657302materialisms
materialists1456982materialists
materialities1566392materialities
rematerializes25144692rematerializes
dematerialize25154913dematerialize_
dematerialized27144463dematerialized
eternalizes20118173_eternalizes
externalizes2855813externalizes
immaterialize2673543immaterialize_
immaterialized2893073immaterialized
internalizes21138693internalizes
lateralize1949053later_alize_
lateralized2147403later_alized
literalizes2048113liter_alizes
materialism1548273materiali_sm
materialist1349523materiali_st
materiality1656083materiali_ty
materializing2595973materializing
materialness1454663materialness
materials11510813material___s
memorializes2556003memorializes
mineralizes2257573miner_alizes
naturalizes2046343natur_alizes
rematerialize24144883rematerialize_
rematerialized26154403rematerialized
serializes19912053__serializes
sterilizes1947643_steri_lizes
aerialists1089524_a_erialists
detribalizes2454554det_ribalizes
editorializes2353774editorializes
eternalize19118504_eternalize_
eternalized21117334_eternalized
etherealizes2453754etherealizes
exteriorizes2853614exteriorizes
externalises1955464externalises
externalize2756384externalize_
externalized2955194externalized
federalizes2445174feder_alizes
generalizes21178274gener_alizes
immaterialisms1793834immaterialisms
immaterialists1883514immaterialists
immaterialities1962874immaterialities
interiorizes2155694interiorizes
internalises12149114internalises
internalize20149594internalize_
internalized22147454internalized
labializes2145794la__bializes
laterizes18513034later___izes
liberalizes2246424liber_alizes
literalize1948744liter_alize_
literalized2147074liter_alized
maderizes2148954mader___izes
makereadies1851444makereadi_es
manorialisms1664484manorialisms
marbelizes2345374ma__rbelizes
marginalizes2463594marginalizes
material10314114material____
materialising16114494materialising
materialistic1774014materialistic
materially1548014material__ly
materialnesses1653914materialnesses
materiels1147844materiel___s
maternities1346014materniti_es
mathematizes2853474mathematizes
matricides1545984mat_ri_cides
matronizes2196844mat_r_onizes
maturities1248454maturi_ti_es
mediatizes2245604m__ediatizes
memorialises1655544memorialises
memorialize2456384memorialize_
memorialized2655304memorialized
metalizes20414244m__e_talizes
metricizes2346764met_ri_cizes
mineralises1357874miner_alises
mineralize2147774miner_alize_
mineralized2346654miner_alized
mineralizer2245304miner_alizer
mineralizers2353384miner_alizers
moralizes20312864m__or_alizes
mutualizes2144944mut__ualizes
nationalizes21178614nationalizes
naturalises1146494natur_alises
naturalize1956894natur_alize_
naturalized2155554natur_alized
paternalisms1656084paternalisms
paternalists1456164paternalists
pictorializes2653454pictorializes
racializes2148464ra__cializes
rationalizes21199254rationalizes
sacralizes2148234sa_cr_alizes
serialises10811564__serialises
serialize18812634__serialize_
serialized20810694__serialized
specializes2446444_specializes
sterilises1048254_steri_lises
sterilize1848304_steri_lize_
sterilized2046764_steri_lized
sterilizer1945514_steri_lizer
sterilizers2043624_steri_lizers
thermalizes2545544_thermalizes
verbalizes2448294__verbalizes
vernalizes2249324__vernalizes
waterlilies1453494waterlili_es
waterlines1348964water__lines

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901157.58016463.1
3Display Results1151150.0761513.2
 (SQL Overall)1786911158.04622208.7
 
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.