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

96 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
colonised1224872(None) 
colonise102514281colonise_
colonises112814011colonises
colonized212710431colonized
canonised1256712canonised
cognised1256312co_gnised
colonies103620012coloni_es
colonist102617932colonis_t
colonists112512502colonists
colonize192312772colonize_
colonizer20309282colonizer
colonizes202613182colonizes
colorized212211772colorized
ozonised1853892_ozonised
agonised10248483_agonised
apologised1444323apologised
botanised1246393botanised
calorized21249663calorized
canonise10511093canonise_
canonises11410803canonises
canonized2147683canonized
caponized2347073caponized
cloned94518803c_lon__ed
clonism1138983c_lonis_m
clonisms1237793c_lonisms
clonked14429563c_lon_ked
clonuses1057133c_lonuses
closed95317963c_lo__sed
cognise1059683co_gnise_
cognises11610043co_gnises
cognized2136293co_gnized
cojoined1856293cojo_ined
colitises11311743colitises
collapsed1443223collapsed
collided12309803col_lided
collied103316673col_li_ed
collinses1138283collinses
colobuses1346133colobuses
colocated1439613colocated
cologned1237153colo_gned
colone85425003colon__e_
colonel94213283colon__el
colones96124433colon__es
coloni85619203coloni___
colonial10411343coloni_al
colonials1147903colonials
colonic115015713coloni__c
colonics123711613coloni_cs
colonising1347643colonising
colonitis1148763colonitis
colonitises1345623colonitises
colonizers21286723colonizers
colonnade1243083colonnade
colonnaded1441943colonnaded
colons86028683colon_s__
colonus94413443colonus__
colorbred1443953colorbred
colored10313473colo__red
colorism122112433coloris_m
colorisms132810793colorisms
colorist102818993coloris_t
colorists112313593colorists
colorize192314203colorize_
colorizer202410623colorizer
colorizes203014523colorizes
coloured1148313colo_ured
communised1744953communised
comprised1648053comprised
connived1436433co_nnived
corniced1368593co_rniced
coronated123313323coronated
coroneted12278323coroneted
creolised1255203creolised
cutinised1245913cutinised
decolonized2454823decolonized
demonised1348233demonised
ebonised1136043_ebonised
economised1544203economised
eulogised1143733eulogised
ionised82911493__ionised
lionised946603_lionised
melodised1345043melodised
motorised1247263motorised
ozonise1646443_ozonise_
ozonises1776373_ozonises
ozonized1745113_ozonized
polarised1269233polarised
polonaise1145853polonaise_
polonaises1245723polonaises
recolonized2345153recolonized
romanised1247923romanised
solarised1068043solarised
solecised1285873solecised
unionised1046533unionised
valorised13247103valorised
womanised1545753womanised

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.420425454.8
2DLD Change Limit148641967.51619776.6
3Display Results96960.0462087.0
 (SQL Overall)178691967.98222386.7
 
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.