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 “ambsace” 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
ambsace135596(None) 
ambsaces1455211ambsaces
amesace1147731amesace
ambage11510602amb_age
ambiance1446062ambiance
amesaces1246692amesaces
embrace1388892embrace
vambrace1743982vambrace
abaca95118043a_b_aca
abaci94718843a_b_aci
aback134816173a_b_ack
abase76023483a_b_ase
abate76627843a_b_ate
abbacy1536623a_bbacy
abduce1197193a_bduce
ablate82219213a_blate
ablaze17239833a_blaze
abrade9313053a_brade
absence1137713a_bsence
airspace1244653airspace
amaze166016603am__aze
ambages1269623amb_ages
ambari103012173amb_ari
ambary134010543amb_ary
ambiances1545713ambiances
ambience1455353ambience
amble95924643amb__le
ambulance1545063ambulance
ambulate1239733ambulate
ambuscade1652423ambuscade
amebae1049633ameba_e
amerce10310513am_erce
amice96122873am__ice
amidase1036733amidase
amirate91115953amirate
amosite9313163amosite
amtrac10109123amtrac_
amtrack15107393amtrack
amtracs1198883amtracs
amusable1237143amusable
amuse75920833amus__e
amusive1246253amusive
amylase1237023amylase
anlace82513923a_nlace
ansae55720973a_nsa_e
ansate64517863a_nsate
apace94718383a__pace
aubade939223aub_ade
brace95629273__brace
camisade1374823camisade
emblaze2045773emblaze
embraced15106673embraced
embracer1496463embracer
embraces14128873embraces
emplace1338263emplace
gambade1336383gamb_ade
imblaze2044323imblaze
lambaste12145013lambaste
mace87345793_m__ace
massacre1244743massacre
massage1039893massage
menace103216943_menace
misact10316693_misact
misate81222693_misate
muscae10410673_muscae
namesake1443243namesake
rubace10310173rub_ace
subrace11313003subrace
subsale9310543subsale
subspace1445683subspace
tambac122210243tamb_ac_
tambacs13219363tamb_acs
umbrae1038683umbra_e
umbrage1236723umbrage
unbrace111910493unbrace
vambraced1942403vambraced
vambraces1843773vambraces

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit134027776.53020524.8
3Display Results77770.0302566.7
 (SQL Overall)178691776.96625651.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.