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

153 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
colonises11281401(None) 
colonies103620011coloni_es
colonise102514281colonise_
colonised12248721colonised
colonists112512501colonists
colonizes202613181colonizes
canonises11410802canonises
clonisms1237792c_lonisms
clonuses1057132c_lonuses
cognises11610042co_gnises
colitises11311742colitises
collinses1138282collinses
colobuses1346132colobuses
colones96124432colon__es
colonials1147902colonials
colonics123711612coloni_cs
colonist102617932colonis_t
colonitis1148762colonitis
colonitises1345622colonitises
colonize192312772colonize_
colonized212710432colonized
colonizer20309282colonizer
colonizers21286722colonizers
colorisms132810792colorisms
colorists112313592colorists
colorizes203014522colorizes
ozonises1776372_ozonises
polonaises1245722polonaises
adonises92611433_adonises
agonises92613163_agonises
apologises1347303apologises
boonies93422483bo_oni_es
botanises1139163botanises
calories102919563calori_es
calorizes202312303calorizes
canonise10511093canonise_
canonised1256713canonised
canonists1158513canonists
canonizes2049593canonizes
caponizes2238703caponizes
chlorides15289753chlorides
chlorines142512353chlorines
chlorites142311963chlorites
chloroses1447683chloroses
clevises1336903c_levises
clones84526563c_lon__es
clonings11307433c_lonings
clonism1138983c_lonis_m
closes85425593c_lo__ses
cognise1059683co_gnise_
cognised1256313co_gnised
cognizes2058033co_gnizes
cojones163512103cojon__es
coldness1137953coldnes_s
coldnesses1338423coldnesses
coleuses1039723col_euses
colicines13311203colicines
colies84837053col__i_es
collapses1344683collapses
collides113214473col_lides
collies94326583col_li_es
colocates13312853colocates
colognes11310603colo_gnes
colone85425003colon__e_
colonel94213283colon__el
colonels104210453colon_els
coloni85619203coloni___
colonial10411343coloni_al
colonic115015713coloni__c
colonising1347643colonising
colonnades1343163colonnades
colons86028683colon___s
colonus94413443colon__us
colorings1247683colorings
colorism122112433coloris_m
colorist102818993coloris_t
colorize192314203colorize_
colorized212211773colorized
colorizer202410623colorizer
colorizers21267603colorizers
colorless1145683colorless
colossus1045183colo_ssus
colossuses1243013colossuses
colpitises1445743colpitises
columnists1444363columnists
communises1646563communises
comprises15510943comprises
conenoses1188903conenoses
conies84338593c__oni_es
conines93827793c__onines
conioses10313313c__onioses
connives1339723co_nnives
cookies133719273co_oki_es
coolies93824963co_oli_es
coolness1037743coolnes_s
coolnesses1237193coolnesses
coonties10513803co_onties
cooties93725733co_oti_es
cornices12713293co_rnices
cornuses10310033co_rnuses
corodies11313693corodi_es
coronates1110816923coronates
cotinines11410073cotinines
creolises1157893creolises
cronies9622503c_roni_es
cullises103111313cul_lises
cutinises1148513cutinises
cyclonites1744913cyclonites
decolonizes2345533decolonizes
demonises12311093demonises
dolomites1248083dolomites
ebonises1039223_ebonises
ecologies12312353ecologi_es
ecologists13310923ecologists
economises1446563economises
eolopiles1145823eolopiles
eulogises1045683eulogises
felonies11310993feloni_es
goonies83618333go_oni_es
ionises72916433__ionises
lionises8310313_lionises
loonies73919543lo_oni_es
lorises73918593__lorises
melodises1247603melodises
moonrises1146723mo_onrises
moronisms1348173moronisms
motorises11311673motorises
mylonites1446453mylonites
ologies8615023_ologi_es
ologists939443_ologists
oologies9312993oologi_es
oologists1039853oologists
ozonides1854293_ozonides
ozonise1646443_ozonise_
ozonised1853893_ozonised
ozonizes1636083_ozonizes
polarises11514073polarises
poloists10910523polo_ists
polonaise1145853polonaise_
poloniums1346053poloniums
recolonizes2245663recolonizes
romanises11311573romanises
solanines9310083solanines
solarises9512703solarises
solecises1189103solecises
soloists869153solo_ists
solonetses1043673solonetses
sorosises947303sorosises
toonies73719883to_oni_es
unionises947163unionises
valorises122210193valorises
womanises1448063womanises
zoonoses1746203zo_onoses

Search took 8 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 Limit1486411537.21620598.8
3Display Results1531530.0632428.6
 (SQL Overall)1786911537.70223200.6
 
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.