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

123 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
covens11491926(None) 
codens94821011codens
copens106119961copens
coven106925041coven_
covers114627961covers
coves105539171cove_s
covets114819641covets
coveys145413501coveys
covins114618061covins
cozens176314921cozens
dovens104413901dovens
ovens86217451_ovens
wovens12449831wovens
avens86419332_avens
caverns124510252caverns
cavers115026842cavers
caves105639702cave_s
civets115212542civets
cloven114211512cloven_
clovers125114662clovers
cloves114918822clove_s
codecs115112932codecs
codeins103715482codeins
coden86128542coden_
coders95426982coders
codes86247292code_s
codons96119462codons
coeds85920162co_eds
cogent9321002cogent
cogons96818112cogons
coigns94410062coigns
coins75834552co_ins
cokes115537192coke_s
coles76055062cole_s
coleus86818272coleus
colins85229042colins
colons86028682colons
comers105328082comers
comes97246992come_s
comets105823582comets
cones76457422cone_s
coneys115218422coneys
conins84327232conins
conns75024232co_nns
cons66057692co__ns
convene123314322convene
convenes132916912convenes
convent123919412convent
convents132614602convents
conveys15308222conveys
cooees85621892cooees
cooers84324562cooers
cooeys114914482cooeys
coons76737282co_ons
copen94826432copen_
copers104629842copers
copes97747102cope_s
corers85231072corers
cores76361852core_s
corns76034762co_rns
corvees124613792corvees
corves115122522corve_s
corvets124715022corvets
cosecs105015212cosecs
coses76949492cose_s
cosets85824402cosets
coseys115215812coseys
cotans81317922cotans
cotes76347842cote_s
cove95837072cove__
coved115027372cove_d
cover105430772cove_r
covert114925502covert
coverts124813812coverts
covet105638942cove_t
covey136121782cove_y
covin105621122covin_
coving124321522coving
covings134511242covings
cowers114625532cowers
coxes145430862coxe_s
cozen165019702cozen_
cozes166033242coze_s
cozeys204610912cozeys
cravens124010122cravens
cuvees1139372cuvees
davens104612912davens
doven94718552doven_
doves94728152dove_s
doyens104810222doyens
dozens164612462dozens
evens84817102_evens
foveas1238622foveas
givens10379732givens
governs1136102governs
havens124514042havens
hovels125413332hovels
hovers124320252hovers
livens94314892livens
lodens74315062lodens
lovers94223432lovers
loves85332012love_s
mavens114312972mavens
movers115117192movers
moves106128422move_s
novels95512502novels
novena936762novena
novenas1036892novenas
omens75618962_omens
opens76118552_opens
oven76624142_oven_
overs85224792_overs
ravens93916882ravens
rouens64814442rouens
roven85521972roven_
rovers95423522rovers
roves84834482rove_s
rowens94515302rowens
sevens93813662sevens
slovens10316572slovens
sowens93613152sowens
tokens104711562tokens
woven115215172woven_

Search took 4 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.360496363.9
2DLD Change Limit825511232.86028864.0
3Display Results1231230.0304100.0
 (SQL Overall)1786911233.25054981.8
 
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.