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

116 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
convoyed1722555(None) 
conveyed17247921conveyed
convoked18236161convoked
condoled123110722condoled
condoned122612022condoned
connoted1138862connoted
consoled112911452consoled
convened143412222convened
conveyer16278142conveyer
convoke16207172convoke_
convoker17226902convoker
convokes17247702convokes
convolved1844082convolved
convoy14348542convoy__
convoys15267022convoy_s
cowboyed1943372cowboyed
unconvoyed1942312unconvoyed
annoyed1185873_annoyed
cannoned11118143cannoned
canoed94618963can_o_ed
cantoned111411523cantoned
canvased14246223canvased
carboyed1637183carboyed
censored11197953censored
cloyed125111563c__loyed
cockeyed2096123cockeyed
cocooned1337293cocooned
coevolved1842453coevolved
colored10313473co_lored
commoved1844763commoved
composed154612063composed
concaved1636223concaved
conceded1438293conceded
concocted1346773concocted
concord12510343conco_rd
condoes104319203condo_es
condole102914953condole_
condoler113412123condoler
condoles113015803condoles
condone102616293condone_
condoner112913413condoner
condones112817393condones
condores113315643condores
conduced14136963conduced
coned86040053con___ed
confided1537453confided
confined14310403confined
conformed1767463conformed
confound1445903confound
confused1437033confused
confuted1437683confuted
congaed11399743con_gaed
congeed113212313con_geed
conglobed1543293conglobed
congoes103617303congo_es
conioses10313323conioses
conjoined1965463conjoined
conjured18117903conjured
conked135019113con__ked
conned95119703con__ned
connived1436433connived
connote9311613connote_
connotes10311453connotes
conoid9818883con_o_id
console92715983console_
consoler102812613consoler
consoles103216153consoles
consorted1239773consorted
consumed1337923consumed
contorted1239483contorted
contoured1237303contoured
contused1138443contused
convected1738783convected
convene123314323convene_
convener132913163convener
convenes132916913convenes
convented15410753convented
converged1636973converged
conversed1538683conversed
converted15311563converted
convex18367743conv__ex
convexes20278273convexes
convey144610223conv__ey
conveyers17267203conveyers
conveyor16245293conveyor
conveys15308223convey_s
convicted1746323convicted
convinced1745363convinced
convokers18246103convokers
convoluted1643703convoluted
convolve1644653convolve
convolves1745323convolves
convoying1835983convoying
convulsed1544383convulsed
cooed84534343co__o_ed
cooeed95917863co__oeed
cooeyed1346893co_oeyed
cooked135921363co__oked
cooled95224593co__oled
cooped114821613co__oped
cordoned12229613cordoned
cornrowed1543623cornrowed
corroded12147513corroded
cottoned1138033cottoned
coved115027373co_v__ed
covered133315293co_vered
coveted133011523co_veted
coyed114623803c___oyed
enjoyed1834523_enjoyed
honeyed1437773hon_eyed
honored11310123hon_ored
invoked1535303_invoked
moneyed1337493mon_eyed
monkeyed1844153monkeyed
nonvoter1186893nonvoter
reconveyed1943473reconveyed

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621167.39019778.3
3Display Results1161160.0333515.2
 (SQL Overall)1786911167.84322783.5
 
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.