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

112 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
cosied9481988(None) 
copied114618561copied
coshed124217541coshed
cosie74728261cosie_
cosier84423751cosier
cosies84932151cosies
costed95623111costed
cozied184112151cozied
bodied103814582bodied
bossed94816532bossed
busied95117222busied
caried94528692caried
cased86032412cas_ed
cashed125124352cashed
casked134815512casked
cessed94615612cessed
cisted95217522cisted
citied94014142citied
closed95317962clos_ed
coaled95022702coaled
coasted104015942coasted
coated94927032coated
coaxed165612512coaxed
cocked155022562cocked
codded114515302codded
coded95433182co_ded
coed77140542co__ed
cogged116416612cogged
coifed124113062coifed
coiled95123932coiled
coined94523602coined
coked124730692co_ked
coled85540752co_led
colies84837052colies
collied103316672collied
combed135516542combed
comped135919872comped
coned86040052co_ned
conies84338592conies
conked135019112conked
conned95119702conned
cooed84534342co_oed
cooeed95917862cooeed
cooked135921362cooked
cooled95224582cooled
cooped114821602cooped
coped105036842co_ped
copier103722892copier
copies104130302copies
copped135221252copped
corded105923352corded
cored85044222co_red
corked135020782corked
corned95224522corned
cosec96320182cos_ec
coses76949492cos_es
coset75748842cos_et
cosey106226712cos_ey
cosher114819902cosher
coshes115022782coshes
cosiest93819852cosiest
cosign958782cosign
cosigned1235722cosigned
cosily113613852cosily
cosine83823512cosine
cosines94122672cosines
cosmid11810642cosmid
cosset84125862cosset
coster84331292coster
coted85033852co_ted
couped115019312couped
coved115027372co_ved
cowed115637842co_wed
cowier113616162cowier
cowled125218382cowled
cowshed1637772cowshed
coxed154322812co_xed
coyed114623802co_yed
cozie163519122cozie_
cozier173315142cozier
cozies174521412cozies
cried84624282c_ried
crosier94116572crosier
crossed105313892crossed
cusped114312042cusped
cussed94917122cussed
dosed76626912dos_ed
dossed84516632dossed
hoised105117432hoised
honied104818392honied
hosed95830982hos_ed
hosier94219612hosier
hosted105020342hosted
joshed174610902joshed
monied94319462monied
moshed124517492moshed
mossed94818892mossed
noised75416232noised
nosed65524552nos_ed
noshed104413502noshed
nosier63716322nosier
osier53518012_osier
poised94918472poised
ponied94920702ponied
posed85828412pos_ed
posies84431432posies
posited10511492posited
posted93722492posted
rosed65930342ros_ed
rosier64221262rosier
rosined84911902rosined
tossed74215222tossed

Search took 7 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.233766914.2
2DLD Change Limit825511125.79614242.8
3Display Results1121120.0931204.3
 (SQL Overall)1786911126.12229188.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.