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

64 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
tamashas1313568(None) 
tamasha12125421tamasha_
gamashes1456942gamashes
abashes12510373_abashes
abasias9711013_abasias
alaskas1136683_alaskas
amahs107819063_ama_h_s
amass77119683_amas__s
amasses93912853_amasses
amusias938573_amusias
atamascos1351813atamascos
calashes13310533calashes
camases114216343camas_es
camass104114183camas__s
camasses12388973camasses
camisas113411923camis_as
camisias12268603camisias
canastas1037693canastas
damasks1435073damas_ks
famishes1658283famishes
halachas16317883halachas
halakhas18386723halakhas
hamadas1339663hama_das
kamalas13339123kama_las
kashas133311903__kashas
lavashes1445573lavashes
marascas1247383marascas
masas75630413__mas_as
mashes115030003__mashes
massas85116463__massas
parashah1646453parashah
parashahs1744743parashahs
pashas115117063__pashas
quamashes2343973quamashes
ramadas1039303rama_das
samadhis1444253samadhis
samaras9312913sama_ras
samosas939293samos_as
samsaras1045873samsaras
samshus12125353sam_shus
smashes123914613_smashes
stramashes1544033stramashes
takahes1436173taka_hes
tamales93216143tama_les
tamals84116623tama__ls
tamanduas1242563tamanduas
tamandus1143943tamandus
tamarao977583tama_rao
tamaraos10105883tamaraos
tamarau9107053tama_rau
tamaraus1096183tamaraus
tamarins10310833tamarins
tamaris9413573tama_ris
tambalas1237033tambalas
tamburas12316043tamburas
tamises92715973tamis_es
tampalas1245473tampalas
taramas9612693tara_mas
tarantas839193tarantas
tarsias74013373ta_rsias
thrashes1487653thrashes
trashes104119253t_rashes
yamalkas1743103yamalkas
zamarras1943803zamarras

Search took 10 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.1731032896.0
2DLD Change Limit146162649.14015991.5
3Display Results64640.0302133.3
 (SQL Overall)178691649.34319125.7
 
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.