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

73 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
ambsaces145521(None) 
ambsace1355961ambsace_
amesaces1246691amesaces
ambages1269622amb_ages
ambiances1545712ambiances
amesace1147732amesace_
embraces14128872embraces
vambraces1843772vambraces
abacas104414723a_b_acas
abacus10349763a_b_acus
abases85720773a_b_ases
abashes12510373a_bashes
abates85825043a_b_ates
abbacies1445493a_bbacies
abduces1286243a_bduces
ablates92416913a_blates
abrades10312083a_brades
abscess1133903a_bs_cess
absences1247673a_bsences
airspaces1344503airspaces
amasses93912853amas_ses
amazes175613473am__azes
ambage11510603amb_age_
ambaries123312383ambaries
ambaris113112163amb_aris
amberies122514693amberies
ambiance1446073ambiance_
ambiences1545253ambiences
ambles105121863amb__les
ambones11312683amb_ones
ambries111614563amb_ries
ambulances1644223ambulances
ambulates1348393ambulates
ambuscades1752273ambuscades
ambushes1535803ambushes
amebiases1343733amebiases
amerces1149853am_erces
amices105018013am__ices
amidases1136653amidases
amirates101114803amirates
amosites10311233amosites
amtracks1696633amtracks
amtracs1198883amtrac_s
amuses85117943amus__es
amylases1346663amylases
anlaces92313733a_nlaces
aubades1038753aub_ades
braces108427773__braces
camisades1474963camisades
emblazes2135673emblazes
embrace1388893embrace_
embraced15106673embraced
embracer1496463embracer
embracers15105153embracers
emplaces1438413emplaces
gambades1435863gamb_ades
imblazes2144723imblazes
lambastes13114693lambastes
maces97139963_m__aces
massacres1344693massacres
massages1159883massages
menaces112715523_menaces
misacts1139353_misacts
namesakes1543233namesakes
rubaces1139313rub_aces
subraces12313033subraces
subsales10310133subsales
subspaces1545673subspaces
tambacs13219363tamb_ac_s
umbrages1336623umbrages
unbraces12229413unbraces
vambrace1743993vambrace_
vambraced1942403vambraced

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.423422437.4
2DLD Change Limit146162736.81321453.4
3Display Results73730.0302433.3
 (SQL Overall)178691737.26624592.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.