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

125 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
colonists11251250(None) 
colonises112814011colonises
colonist102617931colonist_
colorists112313591colorists
canonists1158512canonists
clonisms1237792c_lonisms
colonials1147902colonials
colonics123711612coloni_cs
colonies103620012coloni_es
colonise102514282colonis_e
colonised12248722colonised
colonitis1148762colonitis
colonizes202613182colonizes
colorisms132810792colorisms
colorist102818992colorist_
columnists1444362columnists
ecologists13310922ecologists
ologists939442_ologists
oologists1039852oologists
poloists10910522polo_ists
soloists869152solo_ists
agonists9289833_agonists
apologists1348883apologists
arsonists947413arsonists
biologists1349433biologists
botanists1148203botanists
canoeists1147163canoeists
canonises11410803canonises
canonist10513533canonist_
cellists1038563cel_lists
cetologists1449163cetologists
cladists1136723c_ladists
clonings11307433c_lonings
clonism1138983c_lonis_m
clonuses1057133c_lonuses
coassists11275763coassists
coconuts1246333cocon_uts
coexists1735653co_exists
cognises11610043co_gnises
cohosts12398813coho__sts
coldness1137953coldnes_s
colitises11311743colitises
collagists1345263collagists
collinses1138283collinses
colloquists2253003colloquists
colobuses1346133colobuses
colonels104210453colon_els
colones96124433colon__es
coloni85619203coloni___
colonial10411343coloni_al
colonialists1484993colonialists
colonic115015713coloni__c
colonising1347643colonising
colonitises1345623colonitises
colonize192312773coloni_ze
colonized212710433colonized
colonizer20309283colonizer
colonizers21286723colonizers
colons86028683colon___s
colonus94413443colon__us
colorants1149863colorants
colorcasts1444243colorcasts
colorings1247683colorings
colorism122112433coloris_m
coloristic1447353coloristic
colorizes203014523colorizes
colossus1045183colo_ssus
columnist1346473columnist_
communists1646233communists
consists10310593co_nsists
coolness1037743coolnes_s
copyists1545993co_pyists
coronets103814363coron_ets
cosmists1237993co_smists
crayonists1544133crayonists
cultists10107633cul_tists
cytologists1748013cytologists
demonists1248703demonists
ecologist12314143ecologist_
economists1446953economists
enologists11310623enologists
eulogists1046653eulogists
florists1138813_florists
geologists1279163geologists
hedonists1346053hedonists
holists104413963hol__ists
hornists11208833ho_rnists
ironists839293_ironists
lookists1245713lo_okists
melanists1148623melanists
melodists1246633melodists
monists93614783__monists
monodists1247703monodists
moronisms1348173moronisms
motorists1149913motorists
mycologists1947733mycologists
myologists1648203myologists
neologists1139773neologists
oboists937903_obo_ists
ologist8313833_ologist_
onanists838413_onanists
oncologists1448073oncologists
oologist9313493oologist_
orologists1149823orologists
otologists1149633otologists
ozonises1776373_ozonises
plenists1038253_plenists
polemists1348603polemists
pollists10910823pol_lists
poloist91016323polo_ist_
polonaises1245723polonaises
poloniums1346053poloniums
prologists13311173prologists
simonists1146763simonists
sodomists1255923sodomists
solecists1187073solecists
soloist7915893solo_ist_
solonets838233solon_ets
ufologists1445423ufologists
unionists946213unionists
urologists1148413urologists
violinists1344443violinists
volosts1036563volo__sts
womanists1446763womanists
zoologists2047173zoologists

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.436409841.7
2DLD Change Limit1486411256.50022867.8
3Display Results1251250.0631984.1
 (SQL Overall)1786911256.99925530.9
 
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.