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

98 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
colonial1041134(None) 
colonials1147901colonials
clonal8310912c_lon_al
colonel94213282colon_el
coloni85619202coloni__
colonially1546692colonially
colonic115015712coloni_c
colonics123711612colonics
colonies103620012colonies
colonise102514282colonise
colonist102617932colonist
colonize192312772colonize
colossal1045552colossal
coronal94115762coron_al
oogonial945252oogonial
allodial9117393allodial
alodial899953_alodial
baronial1049483baronial
boltonia1045513boltonia_
boltonias1145123boltonias
calendal1145383calendal
canonical1347213canonical
celosia939463celosia_
celosias1048903celosias
chelonian1454843chelonian
chloral12169983chlo_ral
chorial124214143c_horial
clinal8311553c_lin_al
clinical1247023c_linical
cloacal1135163c_loacal
clonic104914673c_loni_c
cloning103215473c_loning
clonism1138983c_lonism
coaxial16157003co_axial
colinear1045913colinear
collegial1245733collegial
colloidal1244913colloidal
colloquial2153073colloquial
colluvial1443853colluvial
colobi105011083colobi__
colon78630193colon___
colone85425003colon__e
colonels104210453colonels
colones96124433colon_es
colonialism1565433colonialism
colonialist1376723colonialist
colonialize2254623colonialize
colonised12248723colonised
colonises112814013colonises
colonists112512503colonists
colonitis1148763colonitis
colonized212710433colonized
colonizer20309283colonizer
colonizes202613183colonizes
colonnade1243083colonnade
colons86028683colon__s
colonus94413443colon_us
colony115417273colon__y
colorful1344413colorful
coloring11414843coloring
colorism122112433colorism
colorist102818993colorist
colorize192314203colorize
colorman1247893colorman
colorway1644493colorway
colostral1145493colostral
columnal1244413columnal
comitial1248693comitial
congenial1248813congenial
conical11316203c__onical
conidial1159503conidial
conoidal1149013conoidal
cooncan1147233co_oncan
cordial10312953co_rdial
corneal94414503co_rneal
cornual94210173co_rnual
corona83817403coron_a_
coronae94214893coron_ae
coronals103312903coron_als
coronas93916913coron_as
coronel94515223coron_el
cranial92114683c_ranial
cyclonal1544603cyclon_al
ecological1548703ecological
ecotonal1046253ecoton_al
monomial12410133monomial
neocolonial1352553neocolonial
oogonia846483oogonia_
oological1248323oological
pilonidal1243663pilonidal
pogonia1048933pogonia_
pogonias1148513pogonias
polonium1248333polonium
precolonial1554253precolonial
splenial1047183splenial
valonia1048303valonia_
valonias1147473valonias
zoonal1558083zo_on_al

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.423422437.4
2DLD Change Limit146162987.70318974.7
3Display Results98980.0303266.7
 (SQL Overall)178691988.15621909.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.