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

253 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
collect11331459(None) 
collects12279781collects
collet84030361colle_t
callet84536762calle_t
coerect11913352coerect
coldest102514762coldest
collected1447972collected
collector1346392collector
colleen939542colleen
college102410442college
collets93517902collets
complect1659012complect
confect143614272confect
connect113515742connect
convect143114482convect
coolest9318642coolest
correct11513982correct
cullet84727312culle_t
recollect1345702recollect
acrolect1247423acrolect
ballet84733973balle_t
billet86029723bille_t
boldest102613063boldest
bolled94722653bolle_d
bullet84528613bulle_t
cablet104429463cable_t
callant94121223callant
called94126733calle_d
callee84327293calle_e
callees94117783callees
caller85125483calle_r
callers94221963callers
callets93821703callets
calmest11312343calmest
camlet104426583camle_t
caplet104226813caple_t
cathect1439863cathect
celled94420323celle_d
cellist9314423cellist
chalet113825993chale_t
chillest13259593chillest
cholent12313253cholent
cleat76335063c__leat
cleft106222853c__left
clept95725773c__lept
client8316343c_lient
closest94312533closest
closet85226603close_t
coact96130583co__act
coagent10313983coagent
coaled95022713coale_d
coaler84121713coale_r
coalers94419353coalers
coalesce1245423coalesce
coaliest10316223coaliest
coalless1038193coalless
coalpit1148513coalpit
coble94823173coble__
cobles104622883coble_s
codec107120343co_dec_
codecs115112933co_decs
codirect13106293codirect
coeffect1843933coeffect
coenact11311803coenact
coerects1258543coerects
coexert16312363coexert
cogent9321003co_gent
coiled95123943coile_d
coiler84421593coile_r
coilers93619903coilers
coinfect15276843coinfect
colder95121853colde_r
cole66956113co_le__
colead94114643co_lead
coled85540763co_le_d
coles76055063co_le_s
coleus86818273co_leus
colic95726173co_lic_
colics104219903co_lics
colies84837053colie_s
collage102813763collage
collar83816173coll_ar
collard103712923collard
collaret103116703collaret
collars93816573collars
collate92919683collate
collecting1548283collecting
collection1448203collection
collective1747123collective
collectors1446593collectors
colleens1036843colleens
colleger11227933colleger
colleges112410523colleges
collegia1146063collegia
colleted113011663colleted
collide103214793collide
collie83621993coll_ie
collied103316673collied
collier93618153collier
colliers103613583colliers
colliery13307363colliery
collies94326583collies
collins93419833collins
collocate1348663collocate
colloid10312883colloid
collop107312313coll_op
collops112611753collops
collude10337993collude
colly104926773coll__y
colt67158243co_l__t
colter84625093colte_r
colters93522443colters
comet95946073co_me_t
comment1310317703comment
compact153712213compact
compleat14710153compleat
complects1766413complects
conceit113218073conceit
concent114422513concent
concept133314443concept
concert113325223concert
concoct10312903concoct
conduct121411593conduct
confects153110873confects
conflict1547753conflict
congest104618773congest
connects123010563connects
consent93723113consent
contact1144020683contact
content94326153content
contest93523233contest
context163913433context
convects153410993convects
convent123919413convent
convert123721473convert
convict143410983convict
coolant9316463coolant
cooled95224593coole_d
cooler84824713coole_r
coolers93522493coolers
copeck1636943co_peck
coplot10518273copl_ot
copyleft1843983copyleft
coquet174318013coque_t
cornet84436733corne_t
corrects1259573corrects
corset85636223corse_t
corslet9318063corsle_t
corvet114626933corve_t
cosec96320183co_sec_
cosecs105015213co_secs
coset75748843co_se_t
cosiest93819853cosiest
cosset84125863cosse_t
couldest1148353couldest
couldst1037043couldst
coulee8323513coule_e
coulees9315513coulees
couplet114717943couple_t
covalent1349223covalent
covert114925503co_vert
covet105638943co_ve_t
cowiest123614673cowiest
cowled125218393cowle_d
cowlick1835263cowlick
coxless1637743coxless
coyest11316053co_yest
coziest184014353coziest
cromlech1742053cromlech
culet76040343c_ule_t
culled94022473culle_d
culler84322253culle_r
cullers93418853cullers
cullets94015613cullets
culvert123011773culvert
cutlet84924363cutle_t
deflect13399973deflect
dialect101210263dialect
dolled83518073dolle_d
drollest937353drollest
dullest8312633dullest
elect74327033__elect
fellest10313753fellest
fillet95027083fille_t
folles93820473folle_s
foulest10313313foulest
fullest10313343fullest
gallet73630853galle_t
goblet93219483goble_t
goglet84618583gogle_t
goldest92411173goldest
gullet74924833gulle_t
holiest104319623holiest
holler93520613holle_r
hollers103818233hollers
howlet123518343howle_t
illest63615723_illest
inflect1249223inflect
jolliest152910363jolliest
lolled74315823lolle_d
loller63315283lolle_r
lollers72713793lollers
mallet84433053malle_t
millet84030743mille_t
molest85022743mo_lest
mullet84126823mulle_t
neglect1047363neglect
noblest93613563noblest
nonelect10410283nonelect
object17135803_object
obtect10129633_obtect
oldest72114093_oldest
owlet83324463_owle_t
pallet84232653palle_t
pellet83326553pelle_t
polecat11313143po_lecat
pollack1567333pollack
polled94022003polle_d
pollee83623273polle_e
pollees93215333pollees
pollen83416453polle_n
pollens93713303pollens
poller83921853polle_r
pollers93420023pollers
pollex153711163polle_x
pollist9816603pollist
pollock1546843pollock
porrect1159743porrect
prelect111013833prelect
pullet84026333pulle_t
recollects1443683recollects
reelect911515633reelect
reflect123913713reflect
rillet64828853rille_t
rolled74220243rolle_d
roller63919793rolle_r
rollers73117473rollers
rollick1335613rollick
rollout7811943rollout
sallet63734543salle_t
select82621173_select
solleret8512223solleret
solvent10310833solvent
tallest7317093tallest
toilet66228093toile_t
tolled73819033tolle_d
toller63819443tolle_r
tollers73217463tollers
tonlet62924703tonle_t
volley12419743volle_y
volleys13316643volleys
wallet93327093walle_t
willet95124833wille_t

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.1561145455.1
2DLD Change Limit1340272537.31318327.2
3Display Results2532530.1102300.0
 (SQL Overall)1786912537.57923577.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.