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

54 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
lambaste1214501(None) 
lambast11129891lambast_
lambasted14103251lambasted
lambastes13114691lambastes
lambasts12145621lambasts
limbate1139212limba_te
abase76023483_a_bas_e
abate76627843_a_ba_te
alabaster1143353alabaster
ambage11510603_amba_ge
ambsace1355963_ambsace
barbate11314543barba_te
baste74829983___baste
bombast1348223bombast_
bombaster1543803bombaster
bombasts1444953bombasts
cambist13312113cambist_
cambists1437023cambists
clambake1843893clamba_ke
gambade1336383gamba_de
gambas115817513gambas__
hamate113319833ham_a_te
impaste11258003_impaste
labiate91313573la_biate
lactase937953lactas_e
lactate9312693lacta_te
lamas75532793lam_as__
lambada1245643lamba_da
lambadas1354873lambadas
lambasting1543343lambasting
lambdas1246243lambdas__
lambent113711303lambent_
lambert113617113lambert_
lamberts12348793lamberts
lambie103213673lamb__ie
lambiest122410183lambiest_
lamblike1636153lamblike
lambs95921413lamb_s__
lamest84722763lam_est_
lamiae84817453lamia__e
lamias85020613lamias__
laminate103014633laminate
lamister1037653lam_ister
lampas106615953lampas__
lampases1267293lampases
lamster9109913lam__ster
lanate6421263la_na_te
limbas105313203limbas__
lobate82915243l_oba_te
mambas125716243mambas__
mammate104411273mamma_te
radwaste1243843radwaste
ramate83921683ram_a_te
sambas104219263sambas__

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.436409841.7
2DLD Change Limit146162547.25020160.3
3Display Results54540.0301800.0
 (SQL Overall)178691547.71623158.5
 
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.