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

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

64 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
dematerializing2816356(None) 
rematerializing27153521rematerializing
immaterializing29102802immaterializing
materializing2595972__materializing
dematerialize25154913dematerializ__e
dematerialized27144463dematerializ_ed
dematerializes26134823dematerializ_es
demineralizing2792993deminer_alizing
denaturalizing2563513denatur_alizing
materialising16114493__materialising
demoralizing2547144dem__or_alizing
denationalizing26143684denationalizing
desacralizing2653874desa_cr_alizing
detribalizing2654014de__t_ribalizing
editorializing2563334_editorializing
eternalizing2256244_e__ternalizing
externalizing3054614_e_xternalizing
lateralizing2257054__later_alizing
memorializing2764814mem__orializing
rematerialize24144884rematerializ__e
rematerialized26154404rematerializ_ed
rematerializes25144694rematerializ_es
bestializing2456165be_st__ializing
centralizing2458055ce_nt_r_alizing
collateralizing2762065collater_alizing
commercializing3362715com_mercializing
decentralizing2763365decentr_alizing
deformalizing2954225de__formalizing
demobilizing2754475dem__obi_lizing
democratizing2853545dem_ocr_atizing
desexualizing3153745de__sexualizing
destabilizing2653535de_stabi_lizing
devitalizing2645945devit___alizing
emotionalizing2663495_emotionalizing
epithelializing3071795_epithelializing
etherealizing2653325_e_therealizing
exteriorizing3063335_e_xteriorizing
externalising2153395_e_xternalising
federalizing2655245fe__der_alizing
generalizing2346355ge__ner_alizing
immaterialities1962875immaterialities
immaterialize2673545immaterializ__e
immaterialized2893075immaterializ_ed
immaterializes2793365immaterializ_es
internalizing2356215__internalizing
literalizing2256455__liter_alizing
materialities1566395__materialities
materialize2247885__materializ__e
materialized2446555__materializ_ed
materializer2355365__materializ_er
materializers2453175__materializers
materializes2347225__materializ_es
memorialising1853065mem__orialising
mineralizing2466585__miner_alizing
naturalizing2255755__natur_alizing
neutralizing2276445ne_ut_r_alizing
pictorializing2863185_pictorializing
presterilizing26122755presteri_lizing
renationalizing25113745renationalizing
sectarianizing2662345se_ctarianizing
serializing21149405____serializing
sterilizing2146905___steri_lizing
temporalizing2793905tem_por_alizing
theatricalizing3061925theat_ricalizing

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.313570897.8
2DLD Change Limit65874644.00016468.5
3Display Results64640.0461391.3
 (SQL Overall)178691644.35940993.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.