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

136 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
comets10582358(None) 
comers105328081comers
comes97246991come_s
comet95946071comet_
cometh134811681cometh
compts125216651compts
comtes106222811comtes
cosets85824401cosets
covets114819641covets
armets84918352armets
cadets96316512cadets
camels105217082camels
cameos105818002cameos
cames97047312came_s
camlets114314622camlets
carets85330772carets
cements112714222cements
cermets1139712cermets
civets115212542civets
closets94611602closets
coacts105314332coacts
coapts104614012coapts
coasts85719142coasts
coats75635002co_ats
codecs115112932codecs
codens94821012codens
coders95426982coders
codes86247292code_s
coeds85920162co_eds
coempts1335682coempts
cokes115537192coke_s
coles76055062cole_s
coleus86818272coleus
collets93517902collets
colts76633292co_lts
comas95833002com_as
comate104124842comate
comates114123642comates
combats13311682combats
combers134516622combers
combes125321732combes
combos125316612combos
combs116122962com_bs
come87547702come__
comedo11359602comedo
comedos12329072comedos
comedy14378232comedy
comely134213732comely
comer95832692come_r
cometic131215722cometic
comfits14328742comfits
comics124015562comics
comity13312712comity
commas124814572commas
comments142913882comments
commits133812382commits
comous10816502comous
compas125817062compas
compels133210882compels
compete134716552compete
competes144117242competes
compos124818802compos
comps115526052com_ps
compt116328222compt_
comte96125472com_te
cones76457422cone_s
coneys115218422coneys
contes84432912contes
cooees85621892cooees
cooers84324562cooers
cooeys114914482cooeys
coopts105814582coopts
coots75636842co_ots
copens106119962copens
copers104629842copers
copes97747102cope_s
coquets18399892coquets
corers85231072corers
cores76361852core_s
cormels113813372cormels
cornets94820572cornets
corsets94819802corsets
corvets124715022corvets
cosecs105015212cosecs
coses76949492cose_s
coset75748842coset_
coseys115215812coseys
cossets95014282cossets
costs77231142co_sts
cotes76347842cote_s
cots68054842co__ts
counts84618272counts
courts84216172courts
covens114919262covens
covers114627962covers
coverts124813812coverts
coves105539172cove_s
covet105638942covet_
coveys145413502coveys
cowers114625532cowers
coxes145430862coxe_s
coyest11316052coyest
cozens176314922cozens
cozes166033242coze_s
cozeys204610912cozeys
cruets85314952cruets
culets85518512culets
curets84922342curets
cymes1210118922cyme_s
domes85735562dome_s
emmets10349152emmets
foments122912052foments
fumets114311812fumets
godets8410932godets
gomers94116882gomers
homers114821972homers
homes106938812home_s
homeys145012872homeys
loments93413472loments
moments113113122moments
momes95134472mome_s
motets84216192motets
nomes74933122nome_s
nonets64118702nonets
octets839402octets
omens75618962_omens
omers76923192_omers
omits75018262_omits
poets76024442po_ets
pomes94833932pome_s
ramets83517392ramets
romeos84013172romeos
rosets65819952rosets
tomes76037382tome_s
vomers115614942vomers
vomits112610922vomits

Search took 6 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.220812231.8
2DLD Change Limit825511365.09316208.7
3Display Results1361360.0931462.4
 (SQL Overall)1786911365.40633054.2
 
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.