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

114 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
colonized21271043(None) 
colonised12248721colonised
colonize192312771colonize_
colonizer20309281colonizer
colonizes202613181colonizes
colorized212211771colorized
calorized21249672calorized
canonized2147682canonized
caponized2347072caponized
cognized2136292co_gnized
colonies103620012coloni_es
colonise102514282colonise_
colonises112814012colonises
colonizers21286722colonizers
colorize192314202colorize_
colorizer202410622colorizer
colorizes203014522colorizes
decolonized2454822decolonized
ozonized1745112_ozonized
recolonized2345152recolonized
agonized19258993_agonized
apologized2354833apologized
botanized2147283botanized
calorize192712743calorize_
calorizes202312303calorizes
canonised1256713canonised
canonize1959833canonize_
canonizer2046693canonizer
canonizes2049593canonizes
caponize2139113caponize_
caponizes2238703caponizes
carbonized24157053carbonized
chromized2645913chromized
cloned94518803c_lon__ed
clonked14429563c_lon_ked
cocainized2444643cocainized
cognised1256313co_gnised
cognize1957683co_gnize_
cognizer2055863co_gnizer
cognizes2058033co_gnizes
cojoined1856293cojo_ined
collided12309803col_lided
collied103316673col_li_ed
colocated1439613colocated
cologned1237153colo_gned
colone85425003colon__e_
colonel94213283colon__el
colones96124433colon__es
coloni85619203coloni___
colonial10411343coloni_al
colonialized2453633colonialized
colonials1147913colonials
colonic115015713coloni__c
colonics123711613coloni_cs
colonist102617933coloni_st
colonists112512503colonists
colonitis1148763colonitis
colonizing2248813colonizing
colonnade1243083colonnade
colonnaded1441943colonnaded
colorbred1443953colorbred
colored10313473colo__red
colorizers21267603colorizers
coloured1148313colo_ured
communized2645283communized
comprized2567223comprized
connived1436433co_nnived
corniced1368593co_rniced
coronated123313323coronated
coroneted12278323coroneted
creolized2145643creolized
cutinized2146913cutinized
decolonize2245523decolonize_
decolonizes2345533decolonizes
decolorized2445253decolorized
deionized2057153deionized
demonized2239853demonized
ebonized2036973_ebonized
economized2444453economized
eulogized2044953eulogized
geologized2245413geologized
gorgonized2243933gorgonized
hominized2446853hominized
ionized172611293__ionized
ironized1858203_ironized
lionized1837023_lionized
melanized2158573melanized
melodized2245453melodized
motorized2148663motorized
neologized2145753neologized
odorized1945843_odorized
opsonized2174473opsonized
ozonised1853893_ozonised
ozonize1546293_ozonize_
ozonizer1654473_ozonizer
ozonizes1636083_ozonizes
polarized21610283polarized
polemized2346503polemized
pollinized2245643pollinized
prologized2346103prologized
recolonize2145573recolonize_
recolonizes2245663recolonizes
robotized2144613robotized
romanized2149213romanized
salinized1947383salinized
simonized2146523simonized
sodomized22124463sodomized
solarized1969153solarized
solecized2186583solecized
solemnized2244133solemnized
unionized1946673unionized
valorized22257733valorized
volcanized2544923volcanized
womanized2447043womanized

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.423422437.4
2DLD Change Limit1486411147.76619140.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911148.23521699.0
 
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.