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

49 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
frondose124452(None) 
fronds106412342frond_s_
rondos74616722_rondos_
arenose7311373aren_ose
broncos11188073broncos_
brownnose1442583brownnose
condoes104319203_condoes
condole102914953_condole
condone102616293_condone
condos94322333_condos_
drongos935493drongos_
farandole1362973farandole
farinose1136463farin_ose
floccose1543123floccose
foliose10378013f_oliose
fondest11312403f_ondest
fondle104412943f_ond_le
fondles113512613f_ondles
fonds95824823f_ond_s_
fondue104510493f_ond_ue
fondues11399313f_ondues
fondus105210943f_ondus_
fordoes11311963f_ordoes
fordone1149373f_ordone
foredoes12310803foredoes
foredone1249733foredone
frond95316343frond___
fronded12388863frond_ed
frondeur1242783frondeur
frons86124043fron__s_
frontage1296243frontage
frontes104214163frontes_
fronton1037203fronto_n
frontons1136503frontons
fronts94415793fron_ts_
fructose1343663fructose
furanose1144753furan_ose
grandiose1145783grandiose
isodose845373iso_dose
mondos95217333_mondos_
nodose738883_no_dose
prognose1146463prognose
propose112714843pro_pose
proteose10229413proteose
rondo65218373_rondo__
rondure837293_rondure
roose56127093_ro__ose
tondos75115913_tondos_
urinose738483urin_ose

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.1701051123.5
2DLD Change Limit146162496.98320931.1
3Display Results49490.0163062.5
 (SQL Overall)178691497.16924925.5
 
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.