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

55 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
sambucas144416(None) 
sambuca1344341sambuca_
sambas104219262samb__as
sambukes1644192sambukes
samburs11369342sambu_rs
sawbucks1943412sawbucks
tamburas12316052tamburas
abacas104414723_a_bacas
amucks1466003_am_ucks
gambas115817513gamb__as
gambias125010733gamb_ias
gambusias1443343gambusias
hamburgs1643473hamburgs
iambics13425643iambic_s
iambus10468903iambu__s
iambuses1235783iambuses
jumbucks2542953jumbucks
lambadas1354873lambadas
lambdas1246243lamb_das
mambas125716243mamb__as
ramblas112710263ramb_las
rambutan1243403rambutan
rambutans1343103rambutans
sabras85116363sa_b_ras
sacbuts1166473sacbu_ts
sagbuts1065223sagbu_ts
samaras9312913sam_aras
samba95618773samb__a_
sambal105215183samb__al
sambals115213483samb_als
sambar103914163samb__ar
sambars115113843samb_ars
sambhar1444853samb_har
sambhars1544833sambhars
sambhurs1543183sambhurs
sambos104315193samb__os
sambuke1544203sambu_ke
sambur10469503sambu__r
samechs14285353sam_echs
samosas939293sam_osas
samsaras1045873samsaras
samurai945923sam_urai
samurais1046143sam_urais
satsumas1043573satsumas
sauces84919503sa__uces
sauchs115112233sa__uchs
saunas63915433sa__unas
sawbuck1843923sawbuc_k
saxtubas1741913saxtubas
shmucks1833943shm_ucks
tambacs13219363tambac_s
tambalas1237033tambalas
tambouras1343493tambouras
tambura11326463tambura_
tamburs11288613tambu_rs

Search took 9 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.406440125.6
2DLD Change Limit146162557.72018932.9
3Display Results55550.0134230.8
 (SQL Overall)178691558.13921954.9
 
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.