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 “cosets” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

141 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
cosets8582440(None) 
closets94611601closets
comets105823581comets
corsets94819801corsets
cosecs105015211cosecs
coses76949491cose_s
coset75748841coset_
coseys115215811coseys
cossets95014281cossets
costs77231141cos_ts
covets114819641covets
rosets65819951rosets
assets65617662assets
avosets1036662avosets
besets85718802besets
boskets13409472boskets
cadets96316512cadets
carets85330772carets
cases75048382case_s
caskets133910172caskets
castes85631862castes
casts77237792cas_ts
chests114916262chests
choses115825132chose_s
cists76624532cis_ts
civets115212542civets
closers94415322closers
closes85425592close_s
closest94312532closest
closet85226602closet_
coacts105314332coacts
coapts104614012coapts
coasts85719142coasts
coats75635002co_ats
codecs115112932codecs
codens94821012codens
coders95426982coders
codes86247292code_s
coeds85920162co_eds
cokes115537192coke_s
coles76055062cole_s
coleus86818272coleus
collets93517902collets
colts76633292co_lts
comers105328082comers
comes97246992come_s
comet95946072comet_
cometh134811682cometh
compts125216652compts
comtes106222812comtes
cones76457422cone_s
coneys115218422coneys
consents102715892consents
contes84432912contes
cooees85621892cooees
cooers84324562cooers
cooeys114914482cooeys
coopts105814582coopts
coots75636842co_ots
copens106119962copens
copers104629842copers
copes97747102cope_s
copses104922472copse_s
coquets18399892coquets
corers85231072corers
cores76361852core_s
cornets94820572cornets
corses84433462corse_s
corset85636222corset_
corslets1038272corslets
corvets124715022corvets
cosec96320182cose_c
cosey106226712cose_y
coshers123618182coshers
coshes115022782coshes
cosies84932152cosies
cosiest93819852cosiest
cosmos10311752cosmos
coss66143492cos__s
cosset84125862cosset_
cost68057942cos_t_
costa75523732cos_ta
costed95623112costed
coster84331292coster
costers94128332costers
cotes76347842cote_s
cots68054842co__ts
counts84618272counts
courts84216172courts
covens114919262covens
covers114627962covers
coverts124813812coverts
coves105539172cove_s
covet105638942covet_
coveys145413502coveys
cowers114625532cowers
coxes145430862coxe_s
coyest11316052coyest
cozens176314922cozens
cozes166033242coze_s
cozeys204610912cozeys
crests85218702crests
cruets85314952cruets
crusets93811042crusets
culets85518512culets
curets84922342curets
cusecs10509152cusecs
cysts105912772cys_ts
dosers75723632dosers
doses65938502dose_s
godets8410932godets
hosels94218602hosels
hosers95223962hosers
hoses85443172hose_s
hoseys124614002hoseys
hosts85526702hos_ts
insets64016132insets
losels64714582losels
losers65123582losers
loses56742012lose_s
moseys114711702moseys
mosts76028542mos_ts
motets84216192motets
nonets64118702nonets
noses55435642nose_s
octets839402octets
onsets64013542onsets
oses46641512_ose_s
poets76024442po_ets
posers84223972posers
poses74642762pose_s
posits85718712posits
possets94212772possets
posts75228782pos_ts
resets65427612resets
roses56445772rose_s
roset55945242roset_
sets45549502__sets
unsets64116162unsets
upsets8409682upsets
worsets105512842worsets

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511412.34335233.0
3Display Results1411410.0334272.7
 (SQL Overall)1786911412.71965719.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.