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

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

88 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
colorizer20241062(None) 
colonizer20309281colonizer
colorize192314201colorize_
colorized212211771colorized
colorizers21267601colorizers
colorizes203014511colorizes
calorize192712732calorize_
calorized21249662calorized
calorizes202312272calorizes
colonize192312772colonize_
colonized212710432colonized
colonizers21286722colonizers
colonizes202613182colonizes
colorer9312522color__er
decolorizer2354592decolorizer
polarizer2079172polarizer
aphorizer2345403aphorizer
apologizer2244343apologizer
calorie92716883calori_e_
calories102919543calori_es
canonizer2046693canonizer
chloride143310243chloride_
chlorides15289743chlorides
chlorine133013303chlorine_
chlorines142512353chlorines
chlorite133012843chlorite_
chlorites142311963chlorites
codriver1435903co_driver
cognizer2055863co_gnizer
collider113410413col_lider
collier93618153col_li_er
colonies103620013coloni_es
colonise102514283colonise_
colonised12248723colonised
colonises112814013colonises
colorbred1443953colorbred
colored10313473color__ed
colorers10312183color__ers
colorific1644863colorific
colorimeter1553593colorimeter
colorimetry1852763colorimetry
coloring11414843colori_ng
colorings1247683colorings
colorism122112433colori_sm
colorisms132810793colorisms
colorist102818993colori_st
colorists112313593colorists
colorizing2249633colorizing
colormen1247243color_men
colourer1037553colo_urer
comprize2368733comprize_
comprized2567223comprized
comprizes2468943comprizes
contriver1448333contriver
courier93617873co_uri_er
coworker1744683cowor_ker
cowriter13238883co_writer
decolorize2256063decolorize_
decolorized2445253decolorized
decolorizers2453123decolorizers
decolorizes2345873decolorizes
deodorizer2144183deodorizer
economizer2343693economizer
eulogizer1944073eulogizer
lorimer937753__lorimer
loriner7511883__loriner
melodizer2144413melodizer
memorizer22137633memorizer
moorier93113073mo_ori_er
motorize19410423motorize_
motorized2148643motorized
motorizes20410773motorizes
odorize1737403_odorize_
odorized1945843_odorized
odorizes1837203_odorizes
ozonizer1654473_ozonizer
polarize19512653polarize_
polarized21610283polarized
polarizers2165893polarizers
polarizes20513023polarizes
solarize17511473solarize_
solarized1969143solarized
solarizes18511613solarizes
theorizer2144863theorizer
valorize20239613valorize_
valorized22257723valorized
valorizes21249053valorizes
vaporizer23236143vaporizer

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641888.75016987.5
3Display Results88880.0332666.7
 (SQL Overall)178691888.95619952.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.