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

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

108 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
colorized21221177(None) 
calorized21249661calorized
colonized212710431colonized
colorize192314201colorize_
colorizer202410621colorizer
colorizes203014521colorizes
calorize192712732calorize_
calorizes202312282calorizes
colonised12248722colonised
colonize192312772colonize_
colonizer20309282colonizer
colonizes202613182colonizes
colorbred1443952colorbred
colored10313472color__ed
colorizers21267602colorizers
comprized2567222comprized
decolorized2445252decolorized
motorized2148662motorized
odorized1945842_odorized
polarized21610282polarized
solarized1969152solarized
valorized22257722valorized
aphorized2446443aphorized
apologized2354833apologized
arborized2166973arborized
calorie92716893calori_e_
calories102919543calori_es
canonized2147683canonized
caponized2347073caponized
chlorid133211833chlori__d
chloride143310243chloride_
chlorides15289743chlorides
chlorine133013303chlorine_
chlorines142512353chlorines
chlorite133012843chlorite_
chlorites142311963chlorites
chromized2645913chromized
coderived1644793coderived
cognized2136293co_gnized
cojoined1856293cojo_ined
collided12309793col_lided
collied103316673col_li_ed
colocated1439613colocated
cologned1237153colo_gned
colonies103620013coloni_es
colonise102514283colonise_
colonises112814013colonises
colonizers21286723colonizers
colorbreed1552213colorbreed
coloreds1138093color__eds
colorer9312523color__er
colorific1644863colorific
coloring11414843colori_ng
colorings1247683colorings
colorism122112433colori_sm
colorisms132810793colorisms
colorist102818993colori_st
colorists112313593colorists
colorizing2249633colorizing
colormen1247243color_men
coloured1148313colo_ured
comprised1648053comprised
comprize2368733comprize_
comprizes2468943comprizes
contrived1547993contrived
covaried1448003covari_ed
creolized2145643creolized
curarized2176403curarized
decolonized2454823decolonized
decolorize2256063decolorize_
decolorizer2354593decolorizer
decolorizes2345873decolorizes
deodorized2244893deodorized
dollarized2144703dollarized
economized2444453economized
eulogized2044953eulogized
geologized2245413geologized
gloried9169513_glori_ed
melodized2245453melodized
memorized23138993memorized
motorised1247263motorised
motorize19410433motorize_
motorizes20410783motorizes
neologized2145753neologized
notarized1947153notarized
odorize1737403_odorize_
odorizes1837213_odorizes
ozonized1745113_ozonized
polarised1269233polarised
polarize19512653polarize_
polarizer2079173polarizer
polarizes20513023polarizes
polemized2346503polemized
prologized2346103prologized
recolonized2345153recolonized
robotized2144613robotized
soberized2197043soberized
sodomized22124463sodomized
solarised1068043solarised
solarize17511473solarize_
solarizes18511613solarizes
solecized2186583solecized
theorized2245803theorized
valorised13247103valorised
valorize20239613valorize_
valorizes21249063valorizes
vaporized24227353vaporized
velarized2256803velarized

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.1561145455.1
2DLD Change Limit1486411088.55017384.9
3Display Results1081080.0931161.3
 (SQL Overall)1786911088.79920308.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.