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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
ragwort1151074(None) 
ragworts12125801ragworts
bagworm1566352bagworm
fanwort13310732fanwort
figwort1448222figwort
madwort13611362madwort
mugwort1346752mugwort
ragout7317182rag_out
rapport11311222rapport
ribwort1249002ribwort
abort76133583_a_bort
agora6914333_ag_ora
agorot7415003_ag_orot
amort75832203_a_mort
aport75432173_a_port
argot67728653arg_o_t
artwork1447093artwork
assort64916383_assort
awlwort1356353awlwort
bagworms1645213bagworms
braggart1245613braggart
carport11316033carport
cavort11316173ca_vort
dagwood1344833dagwood
damewort1447443damewort
danewort1258243danewort
daywork1845653daywork
dropwort1446283dropwort
earworm1238743earworm
faggot1139053faggo_t
fagot9323403fag_o_t
fanworts1446103fanworts
felwort13410583felwort
figworts1544683figworts
hagborn1344953hagborn
leadwort1247473leadwort
legwork1545663legwork
lugworm1344903lugworm
lungwort1245493lungwort
madworts1456173madworts
maggot10311713maggo_t
magot8326393mag_o_t
mugworts1443443mugworts
rackwork1645583rackwork
ragouts838543rag_outs
ragtop936683ragto_p
ragtops1035453ragtops
ragweed1235073ragweed
rainout7314393rainout
rampart11311993rampart
rancor8810373rancor_
rancors9811373rancors
rapports1245963rapports
raptor83912823raptor_
raptors94213353raptors
rasbora945943rasbora
rawer84623733ra_wer_
rawest93615063ra_west
razor143012603ra_zor_
razors154711663ra_zors
reassort8410683reassort
report85326023r_eport
resort65728623r_esort
retort66831153r_etort
reword106321413r_eword
rewore938030163r_ewore
rework136619793r_ework
reworn98122203r_eworn
ribworts1345093ribworts
rigor62714053rig_or_
rigors72813713rig_ors
ringworm1444673ringworm
roadwork1645473roadwork
saltwort1148603saltwort
sandwort12410083sandwort
soapwort1347553soapwort
starwort1198683starwort
warwork1757583warwork
warworn1357353warworn
waxwork24104883waxwork
waxworm2264573waxworm
wayworn1675293wayworn
wort76654753___wort

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 Filter1786911340270.423422437.4
2DLD Change Limit134027836.40620922.1
3Display Results83830.0302766.7
 (SQL Overall)178691836.85926052.0
 
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.