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

163 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
colonist10261793(None) 
colonise102514281colonise
colonists112512501colonists
colorist102818991colorist
canonist10513532canonist
clonism1138982c_lonism
colones96124432colones_
coloni85619202coloni__
colonial10411342colonial
colonic115015712coloni_c
colonics123711612colonics
colonies103620012colonies
colonised12248722colonised
colonises112814012colonises
colonize192312772colonize
colons86028682colon_s_
colonus94413442colonus_
colorism122112432colorism
colorists112313592colorists
columnist1346472columnist
ecologist12314142ecologist
ologist8313832_ologist
oologist9313492oologist
poloist91016322polo_ist
soloist7915892solo_ist
agonist82615403_agonist
apologist12412403apologist
arsonist8412013arsonist
biologist12412343biologist
botanist10412033botanist
canoeist10310693canoeist
canonise10511093canonise
canonists1158513canonists
cellist9314423cel_list
cetologist13412253cetologist
cladist10311973c_ladist
clones84526563c_lones_
clonic104914673c_loni_c
cloning103215473c_loning
clonisms1237793c_lonisms
clonks125013473c_lonks_
clons75228133c_lon_s_
clonus85212413c_lonus_
closest94312533c_losest
clownish1643803clownish
coassist10298803coassist
coconut11511473cocon_ut
coconuts1246333coconuts
codons96119463codon_s_
coexist1638583co_exist
cognise1059683co_gnise
cogons96818113cogon_s_
cohost115217213coho__st
cojoins1638993cojoins_
cojones163512103cojones_
coldest102514763col_dest
coldish1399303col_dish
coldness1137953coldness
colins85229043colin_s_
colitis92617353colitis_
collagist1248013collagist
collins93419833collins_
colloquist2154213colloquist
colobi105011083colobi__
colobus11389373colobus_
colognes11310603colognes_
cologs96517353colo_gs_
colon78630193colon___
colone85425003colon__e
colonel94213283colon_el
colonels104210453colonels
colonialist1376723colonialist
colonials1147903colonials
colonising1347643colonising
colonitis1148763colonitis
colonized212710433colonized
colonizer20309283colonizer
colonizes202613183colonizes
colony115417273colon__y
colorant10414723colorant
colorcast1346553colorcast
colorfast1445033colorfast
coloring11414843coloring
colorisms132810793colorisms
coloristic1447353coloristic
colorize192314203colorize
colors86622373colo_rs_
colossi935673colo_ssi
colours95913443colours_
coltish121310933col_tish
columnists1444363columnists
commonest1549253commonest
communist1548113communist
consist9316033co_nsist
coolest9318643co_olest
coolish12312523co_olish
coolness1037743coolness
coons76737283co_on_s_
copyist1439053co_pyist
corniest102117303co_rniest
coronas93916913coronas_
coronet94227173coron_et
coronets103814363coronets
cosmist11311333co_smist
crayonist1446253crayonist
cronish12310863c_ronish
cultist91412713cul_tist
cytologist16410533cytologist
demonist11413463demonist
ecologists13310923ecologists
economist1348883economist
enologist10314123enologist
eulogist949043eulogist
florist10314243_florist
geologist11611783geologist
gooniest93213003go_oniest
hedonist1249553hedonist
holist94723213hol__ist
hornist102314823ho_rnist
ironist7314843_ironist
lookist1139563lo_okist
looniest83313253lo_oniest
melanist10313053melanist
melodist1149743melodist
monist84324983__monist
monodist11310923monodist
mooniest103014173mo_oniest
moonish123311043mo_onish
moronism1249323moronism
motorist10314413motorist
mycologist18410353mycologist
myologist15411093myologist
neologist10712813neologist
oboist8312683_obo_ist
ologists939443_ologists
onanist7314633_onanist
oncologist13410413oncologist
oologists1039853oologists
oolongs845953oolongs_
orologist10313103orologist
otologist10412813otologist
ozonise1646443_ozonise
plenist9314333_plenist
polemist12412363polemist
pollist9816603pol_list
poloists10910523polo_ists
polonaise1145853polonaise
polonium1248333polonium
prologist12315083prologist
simonist10410723simonist
sodomist1157633sodomist
solecist10910783solecist
soloists869153solo_ists
solonets838233solonets
solons65120023solon_s_
soonest7415593so_onest
ufologist1347053ufologist
unionist8410353unionist
urologist10411053urologist
violinist1247373violinist
volost9412643volo__st
womanist13410433womanist
zoologist1949693zoologist

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.420425454.8
2DLD Change Limit1461621637.81318707.5
3Display Results1631630.0802037.5
 (SQL Overall)1786911638.31321495.4
 
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.