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

249 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
colonel9421328(None) 
colone85425001colone_
colonels104210461colonels
colones96124431colones
coronel94515221coronel
boloney1247762boloney
calomel1138072calomel
clonal8310912c_lonal
clone75728162c_lone_
cloned94518802c_loned
cloner84418092c_loner
clones84526562c_lones
cojones163512102cojones
cologne1039362cologne_
cologned1237152cologned
colognes11310602colognes
colon78630192colon__
colonelcy1642862colonelcy
coloni85619202colon_i
colonial10411342colonial
colonic115015712colonic
colonies103620012colonies
colons86028682colon_s
colonus94413442colonus
colony115417272colon_y
colored10313472colored
colorer9312522colorer
columel1136272columel
cornel84020052co_rnel
coronal94115762coronal
coronels104012152coronels
coroner94218202coroner
coronet94227172coronet
alone55732963_alone_
baloney1237483baloney
boloneys1334503boloneys
botonee9311833botonee
cajones163311333cajones
calomels1236133calomels
caloyer1238143caloyer
calzone1848623calzone_
calzones1948763calzones
cannel84216403c_annel
celotex1635023celotex
chalone12312103chalone_
chalones13312173chalones
channel123910483channel
charnel124010053charnel
chloral12169983chloral
choline122915383choline_
cholines132214493cholines
chunnel12395303chunnel
clinal8311553c_linal
cline76428533c_line_
clines84926043c_lines
clon66232483c_lon__
cloners94514823c_loners
clonic104914673c_lonic
clonk114417443c_lon_k
clonked14429563c_lonked
clonks125013473c_lonks
clons75228133c_lon_s
clonus85212413c_lonus
close76425223c_lose_
closed95317973c_losed
closely1237053c_losely
closer84918203c_loser
closes85425593c_loses
closet85226603c_loset
clove105619443c_love_
cloven114211513c_loven
clover114617123c_lover
cloves114918823c_loves
clowned13447733clowned
cloyed125111563c_loyed
cloze165517543c_loze_
clozes174915563c_lozes
coannex1635513coannex
cockney1835873cockney
coconut11511473coconut
cocooned1337293cocooned
cocounsel1342513cocounsel
codon86522853codon__
codons96119463codon_s
coelome1139693coelome_
coelomes1239293coelomes
cogon89120903cogon__
cogons96818113cogon_s
cohune1189423cohune_
cohunes1249713cohunes
coigne94612193coigne_
coigned11418663coigned
coignes103912153coignes
coined94523603co_ined
coiner84323783co_iner
cojoined1856293cojoined
colander1139033colander
colder95121853col_der
coldness1137953coldness
cole66956113col__e_
coled85540763col__ed
coles76055063col__es
colies84837053col_ies
colin76231693colin__
colinear1045913colinear
colins85229043colin_s
colleen939543colleen
collet84030363col_let
collie83621993collie_
collied103316683collied
collier93618153collier
collies94326583collies
colobi105011083colo_bi
colobus11389373colobus
colog86619933colo__g
cologs96517353colo_gs
colonials1147913colonials
colonics123711613colonics
colonise102514283colonise
colonised12248723colonised
colonises112814013colonises
colonist102617933colonist
colonize192312773colonize
colonized212710433colonized
colonizer20309283colonizer
colonizes202613183colonizes
color76123743colo__r
coloreds1138093coloreds
colorers10312183colorers
colorful1344413colorful
colormen1247243colormen
colors86622373colo_rs
colossal1045563colossal
colossi935673colossi
colour85915093colo_ur
coloured1148313coloured
colourer1037563colourer
colours95913443colours
colter84625093col_ter
columels1244813columels
columnal1244413columnal
columnea1243673columnea
columned1334923columned
colure8314163colure_
colures9315143colures
commoner142710633commoner
comose105016853comose_
compel124412893co_mpel
compone136517193compone_
condone102616293condone_
condoned122612023condoned
condoner112913413condoner
condones112817393condones
cone67256963c__one_
coned86040053c__oned
cones76457423c__ones
coney105932883c__oney
conine84528553conine_
conines93827793conines
conned95119703co_nned
conner84423963co_nner
cooed84534343co_o_ed
cooee74531023co_o_ee
cooeed95917863co_oeed
cooees85621893co_oees
cooer74831013co_o_er
cooey105828223co_o_ey
cooked135921363co_oked
cooker124722453co_oker
cookey155414333co_okey
cool66940493co_o__l
cooled95224593co_oled
cooler84824713co_oler
coolie83821603coolie_
coolies93824963coolies
coolness1037743coolness
coon67248943co_on__
coons76737283co_on_s
cooped114821613co_oped
cooper104221123co_oper
cooter85128613co_oter
corbel103715973co_rbel
cordoned12229613cordoned
cormel103815603co_rmel
cornea84018933co_rnea
corneal94414503co_rneal
corned95224523co_rned
cornels94716663co_rnels
corner84625623co_rner
cornet84436733co_rnet
corona83817403coron_a
coronae94214893coronae
coronals103312913coronals
coronas93916913coronas
coroners104016233coroners
coronets103814363coronets
cosine83823513cosine_
cosines94122673cosines
costrel9310373costrel
cottoned1138033cottoned
counsel948543counsel
coyote11411783coyote_
coyotes12410703coyotes
cozened19349183cozened
cozener18328953cozener
crenel84213063c_renel
crone75231333c_rone_
crones84729243c_rones
crooned103813353crooned
crooner93714043crooner
cyclonal1544603cyclonal
cyclone1437243cyclone_
cyclones1537483cyclones
doblones1136763doblones
ecotonal1046253ecotonal
ecotone938583ecotone_
ecotones1039493ecotones
gobonee1077783gobonee
gooney106612313go_oney
ionone6313443ionone_
ionones7313883ionones
lone45849133__lone_
lonely92912473__lonely
loner55431043__loner
looney94712413lo_oney
losel54419423__losel
moline84422033moline_
mooned94216643mo_oned
mooner85317833mo_oner
ochone11311293ochone_
oolong738073oolon_g
oolongs845953oolongs
ozone14310613_ozone_
ozones1539393_ozones
ronnel63310883ro_nnel
solgel737963sol_gel
soloed74515743solo_ed
solon55026133solon__
solonets838233solonets
solonetz1744853solonetz
solons65120023solon_s
sooner64220463so_oner
taloned8310223taloned
tolane64316583tolane_
tolanes74216313tolanes
violone1037153violone_
violones1137383violones
zoonal1558083zo_onal
zooned164011083zo_oned

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 Filter1786911340270.440406115.9
2DLD Change Limit1340272496.92019368.1
3Display Results2492490.1102263.6
 (SQL Overall)1786912497.47023921.2
 
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.