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

168 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
colonels10421045(None) 
colonel94213281colonel_
colones96124431colone_s
coronels104012141coronels
boloneys1334502boloneys
calomels1236132calomels
cloners94514822c_loners
clones84526562c_lone_s
cojones163512102cojone_s
coldness1137952coldness
colognes11310602cologne_s
colone85425002colone__
colonelcy1642862colonelcy
colonials1147902colonials
colonics123711612colonics
colonies103620012colonies
colons86028682colon__s
colonus94413442colon_us
coloreds1138092coloreds
colorers10312182colorers
columels1244812columels
coolness1037742coolness
cornels94716662co_rnels
coronals103312902coronals
coronel94515222coronel_
coroners104016222coroners
coronets103814362coronets
solonets838232solonets
baloneys1334663baloneys
boldness1136973boldness
boloney1247763bolone_y
cajones163311333cajone_s
calmness1236643calmness
calomel1138073calomel_
caloyers1337343caloyers
calzones1948763calzone_s
cannels93413363c_annels
canoness1039393canoness
chalones13312173chalone_s
channels13388493channels
charnels13328173charnels
chlorals13148033chlorals
cholines132214493choline_s
chunnels13304553chunnels
clines84926043c_line_s
clonal8310913c_lonal_
clone75728163c_lone__
cloned94518803c_lone_d
cloner84418093c_lone_r
clonks125013473c_lon_ks
clons75228133c_lon__s
clonus85212413c_lon_us
closely1237053c_losely
closers94415323c_losers
closes85425593c_lose_s
closets94611603c_losets
clovers125114663c_lovers
cloves114918823c_love_s
clozes174915563c_loze_s
cockneys1934493cockneys
coconuts1246333coconuts
cocounsels1442083cocounsels
codons96119463codon__s
coelomes1239293coelome_s
cogons96818113cogon__s
cohunes1249713cohune_s
coignes103912153coigne_s
coiners93620753co_iners
colanders1238013colanders
coles76055063col__e_s
coleus86818273col__eus
colies84837053col_ie_s
colinear1045913colinear
colins85229043colin__s
colleens1036843colleens
collets93517903col_lets
colliers103613583colliers
collies94326583collie_s
colobus11389373colo_bus
cologne1039363cologne__
cologned1237153cologne_d
cologs96517353colo__gs
colon78630193colon___
colonelcies1552803colonelcies
coloni85619203colon__i
colonial10411343colonial
colonic115015713colon_ic
colonise102514283colonise
colonises112814013colonises
colonist102617933colonist
colonists112512503colonists
colonitis1148763colonitis
colonize192312773colonize
colonizers21286723colonizers
colonizes202613183colonizes
colony115417273colon__y
colored10313473colore_d
colorer9312523colore_r
colorless1145683colorless
colors86622373colo__rs
colossus1045183colossus
colourers1136473colourers
colours95913443colo_urs
colters93522443col_ters
columel1136273columel_
columneas1343013columneas
colures9315143colure_s
commoners15339783commoners
compels133210883co_mpels
condoners122811513condoners
condones112817393condone_s
cones76457423c__one_s
coneys115218423c__oneys
conines93827793conine_s
conners94023113co_nners
cooees85621893co_o_ees
cooers84324563co_o_ers
cooeys114914483co_o_eys
cookers134619463co_okers
cookeys16478503co_okeys
coolers93522493co_olers
coolies93824963coolie_s
cools75632633co_o__ls
coons76737283co_on__s
coopers114019483co_opers
cooters94525723co_oters
corbels113813593co_rbels
cormels113813373co_rmels
corneas94717003co_rneas
cornel84020053co_rnel_
corners94723313co_rners
cornets94820573co_rnets
coronal94115763coronal_
coronas93916913coron_as
coroner94218203corone_r
coronet94227173corone_t
cosines94122673cosine_s
cosiness103214283cosiness
costrels1038933costrels
counsels1037573counsels
coyness1277323co_yness
coyotes12410703coyote_s
cozeners19297783cozeners
coziness19319823coziness
crenels93711013c_renels
crones84729243c_rone_s
crooners103911393crooners
cyclones1537483cyclone_s
doblones1136763doblone_s
ecotones1039493ecotone_s
gooneys11407073go_oneys
holiness112512503holiness
ionones7313883ionone_s
lonely92912473__lonely
loners64225813__loners
looneys10487013lo_oneys
losels64714583__losels
mooners94015343mo_oners
oldness836403_oldness
oolongs845953oolon_gs
ozones1539393_ozone_s
ronnels7318613ro_nnels
soleness8814263soleness
solonetz1744853solonetz
solons65120023solon__s
sooners73916643so_oners
tolanes74216313tolane_s
violones1137383violone_s

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621687.42019698.4
3Display Results1681680.0632666.7
 (SQL Overall)1786911687.88922650.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.