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

61 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
tamaraos1010588(None) 
tamarao977591tamarao_
tamaraus1096181tamaraus
samaras9312912samara_s
tamarack1644362tamarack
tamaracks1743752tamaracks
tamarau9107062tamara_u
tamarins10310842tamarins
tamaris9413602tamar_is
timaraus1095072timaraus
zamarros1942682zamarros
amtracs1198883_amtracs
atamascos1351813atamascos
bacalaos1245863bacalaos
cameras11313363camera_s
carabaos1238083carabaos
catamarans1453193catamarans
damars93815003damar__s
hamadas1339673hamada_s
kamalas13339123kamala_s
maras75443303__mara_s
ramadas1039303ramada_s
samara8313853samara__
samsaras1045873samsara_s
samurais1046153samurais
sataras7315063satara_s
tabards10310383tabar_ds
tabarets10287243tabarets
tagrags936123ta_grags
talars66021683talar__s
tamales93216153tama_les
tamals84116633tam__als
tamandus1143943tamandus
tamari8313413tamar__i
tamarillos1252123tamarillos
tamarin9311923tamar_in
tamarind1147023tamarind
tamarinds1244163tamarinds
tamarisk1445473tamarisk
tamarisks1543633tamarisks
tamashas13135683tamashas
tambacs13219363tam_bacs
tambaks15218153tam_baks
tambalas1237033tambala_s
tamburas12316053tambura_s
tamers84224033tamer__s
tampalas1245473tampala_s
tampans113310983tam_pans
tangrams1136163tangrams
tantaras8269543tantara_s
tantras73112093tantra_s
tapalos938813tapa_los
taramas9612713tarama_s
taros55640823t__ar_os
tatars64619793tatar__s
tiaras6314553t_iara_s
timarau975853timara_u
trimarans1144693trimarans
tuataras844863tuatara_s
zamarras1943803zamarras
zamarro1842883zamarro_

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 Limit146162617.53319402.9
3Display Results61610.0134692.3
 (SQL Overall)178691617.96622431.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.