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

48 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
dichotomization32101821dichotomization_
dichotomizing3192424dichotomiz__i_ng
decolonization26146025dec_olonization_
decolonizations27145965dec_olonizations
decolorization26136415dec_olorization_
decolorizations27136105dec_olorizations
diazotization2264305diazot__ization_
diazotizations2353685diazot__izations
victimization2984595vic__timization_
victimizations3064285vic__timizations
atomization2249246____atomization_
atomizations2348476____atomizations
cicatrization2675416cic_at_rization_
cicatrizations2794916cic_at_rizations
colonization232010236__c_olonization_
colonizations24229426__c_olonizations
colorization231711196__c_olorization_
colorizations241410356__c_olorizations
dechlorination2053416dech_lorination_
dechlorinations2153116dech_lorinations
decontamination2083256decontamination_
deodorization2456466d__eodorization_
deodorizations2556326d__eodorizations
diagonalization2663016diagonalization_
dichotomist1974186dichotomi_st____
dichotomists2093226dichotomi_st___s
dichotomize28103256dichotomiz_____e
dichotomized30132806dichotomiz____ed
dichotomizes29103496dichotomiz____es
digitalization2586366di_gitalization_
digitalizations2686186di_gitalizations
digitization2347686di_git__ization_
digitizations2447086di_git__izations
disintoxication2572556disintoxication_
factorization2756286fac__torization_
factorizations2855766fac__torizations
fictionization2863606fic_tionization_
fictionizations2953506fic_tionizations
itemization2248346_i___temization_
itemizations2347846_i___temizations
motorization2349706___motorization_
motorizations2449126___motorizations
picturization2674986pic__turization_
picturizations2764686pic__turizations
recolonization25155886rec_olonization_
recolonizations26165766rec_olonizations
rhythmization3362056__rhythmization_
rhythmizations3461726__rhythmizations

Search took 6 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.310576422.6
2DLD Change Limit65874485.06313010.9
3Display Results48480.0331454.5
 (SQL Overall)178691485.40633054.2
 
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.