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

77 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
sambukes164419(None) 
sambuke1544201sambuke_
iambuses1235782iambuses
sambucas1444162sambucas
samburs11369342sambu_rs
abuses85119103_a_buses
ambages1269623_ambages
ambles105121863_amb_les
ambones11312683_ambones
ambries111614553_ambries
ambushes1535803_ambushes
ampules1189433_ampules
amuses85117943_am_uses
arbutes939703_arbutes
barbules1238043barbules
campuses1437773campuses
clambakes1943313clambakes
gambades1435863gambades
gambes116318313gamb__es
gambles124016203gamb_les
gamboges1435653gamboges
hambones1539673hambones
hamburgs1643473hamburgs
iambus10468903iambu__s
imbues1037983_imbu_es
jambes175914053jamb__es
kabukis1243193ka_bukis
lambies113015113lamb_ies
limbuses1234903limbuses
mamboes135011823mamb_oes
mamelukes1741903mamelukes
mamluks1543313mamluk_s
nimbuses1244663nimbuses
parbakes1638343parbakes
rambles113118313ramb_les
rampikes1635393rampikes
rebukes134210553_rebukes
sabes76437463sa_b__es
sabines94318483sa_bines
sables85026693sa_b_les
sabres85520863sa_b_res
sacbuts1166473sacbu_ts
saccules1237033saccules
sacques18106863sacqu_es
sagbuts1065223sagbu_ts
sakes95540753sa___kes
salukis1136033sa_lukis
salutes73716253sa_lutes
sambaed1238303samb_aed
sambals115213483samb_als
sambars115113843samb_ars
sambas104219263samb__as
sambhars1544833sambhars
sambhurs1543183sambhurs
sambos104315193samb__os
sambuca1344343sambu_ca
sambur10469503sambu__r
samekhs16303923sam_ekhs
sameks12409323sam_ek_s
samites93118713sam_ites
samples112815453sam_ples
sauces84919503sa__uces
sautes63924913sa__utes
sawbones13126643sawbones
sawbucks1943413sawbucks
shambles15159043shamb_les
shamuses1336153sham_uses
sjamboked2541723sjamboked
sjamboks2342233sjambok_s
smokes124814343s_m_okes
tambaks15218153tambak_s
tamburas12316053tamburas
tamburs11288613tambu_rs
wambles143714023wamb_les
wammuses1543493wammuses
wampuses1534113wampuses
wamuses1237023wam_uses

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.406440125.6
2DLD Change Limit146162777.00020880.3
3Display Results77770.0332333.3
 (SQL Overall)178691777.43924020.8
 
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.