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

143 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
colonize19231277(None) 
colonise102514281colonise
colonized212710431colonized
colonizer20309281colonizer
colonizes202613181colonizes
colorize192314201colorize
calorize192712732calorize
canonize1959832canonize
caponize2139112caponize
cognize1957682co_gnize
colone85425002colon__e
coloni85619202coloni__
colonial10411342colonial
colonic115015712coloni_c
colonics123711612colonics
colonies103620012colonies
colonised12248722colonised
colonises112814012colonises
colonist102617932colonist
colonizers21286722colonizers
colorized212211772colorized
colorizer202410622colorizer
colorizes203014522colorizes
decolonize2245522decolonize
ozonize1546292_ozonize
recolonize2145572recolonize
agonize172911403_agonize
apologize2146123apologize
botanize1948753botanize
calorie92716893calori_e
calorized21249663calorized
calorizes202312293calorizes
canonise10511093canonise
canonized2147683canonized
canonizer2046693canonizer
canonizes2049593canonizes
caponized2347073caponized
caponizes2238703caponizes
carbonize22169043carbonize
chloride143310243chloride
chlorine133013303chlorine
chlorite133012843chlorite
chromize2447683chromize
clone75728163c_lon__e
clonic104914673c_loni_c
cloning103215473c_loning
clonism1138983c_lonism
cloze165517543c_lo__ze
cocainize2245783cocainize
cognise1059683co_gnise
cognized2136293co_gnized
cognizer2055863co_gnizer
cognizes2058033co_gnizes
colicine12312993colicine
collide103214793col_lide
collie83621993col_li_e
colobi105011083colobi__
colocate12313443colocate
cologne1039363colo_gne
colon78630193colon___
colonel94213283colon_el
colonels104210453colonels
colones96124433colon_es
colonialize2254623colonialize
colonials1147903colonials
colonists112512503colonists
colonitis1148763colonitis
colonizing2248813colonizing
colonnade1243083colonnade
colons86028683colon__s
colonus94413443colon_us
colony115417273colon__y
coloring11414843coloring
colorism122112433colorism
colorist102818993colorist
colorizers21267603colorizers
communize2446283communize
comprize2368733comprize
conine84528553c__onine
connive1238993co_nnive
cookie123716043co_oki_e
coolie83821603co_oli_e
coontie9311423co_ontie
cootie84223093co_oti_e
cornice11612933co_rnice
coronae94214893coron_ae
coronate103018213coronate
cotinine10311493cotinine
creolize1947183creolize
cutinize1948533cutinize
cyclonite1645453cyclonite
decolonized2454823decolonized
decolonizes2345533decolonizes
decolorize2256063decolorize
deionize1858683deionize
demonize20311533demonize
dolomite1148133dolomite
ebonize1838153_ebonize
economize2245243economize
eolopile1045863eolopile
eulogize1845543eulogize
geologize2046363geologize
goonie73615563go_oni_e
gorgonize2044723gorgonize
hominize2248593hominize
ionize154613873__ionize
ironize16610373_ironize
lionize1668823_lionize
loonie64216453lo_oni_e
melanize19410303melanize
melodize2046663melodize
motorize19410433motorize
mylonite1346823mylonite
neologize1946963neologize
odorize1737403_odorize
opsonize19114993opsonize
ozonide1754963_ozonide
ozonise1646443_ozonise
ozonized1745113_ozonized
ozonizer1654473_ozonizer
ozonizes1636083_ozonizes
polarize19512653polarize
polemize2148673polemize
pollinize2046893pollinize
polonaise1145853polonaise
polonium1248333polonium
prologize2147963prologize
recolonized2345153recolonized
recolonizes2245663recolonizes
robotize1945693robotize
romanize19311013romanize
salinize1739683salinize
simonize1947813simonize
sodomize20135253sodomize
solanine8311533solanine
solarize17511473solarize
solecize1998383solecize
solemnize2044933solemnize
toonie63617993to_oni_e
unionize1747063unionize
valorize20239613valorize
volcanize2345733volcanize
womanize2248163womanize

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621437.75018859.6
3Display Results1431430.0632269.8
 (SQL Overall)1786911438.24921662.1
 
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.