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 “embraces” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

140 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
embraces1412887(None) 
embrace1388891embrace_
embraced15106671embraced
embracer1496461embracer
embracers15105151embracers
ambsaces1455212ambsaces
braces108427772__braces
emblazes2135672emblazes
embraceor1593022embraceor
embraceors16112752embraceors
embracery1893202embracery
embrues1136472embr_ues
embrutes1245192embrutes
emirates101214852emirates
emplaces1438412emplaces
membranes1545562membranes
reembraces1643892reembraces
subraces12313032subraces
umbrages1336622umbrages
unbraces12229412unbraces
vambraces1843772vambraces
abrades10312073_abrades
ambages1269623amb_ages
ambaries123312383ambaries
ambiances1545713ambiances
ambries111614553ambr_ies
ambsace1355963ambsace_
amerces1149853amer_ces
amesaces1246693amesaces
amirates101114793amirates
amtracks1696633amtracks
amtracs1198883amtrac_s
boraces113716853_boraces
brace95629273__brace_
braced115420603__braced
bracer104620583__bracer
bracers114616703__bracers
braches144621223__braches
brachs134415753__brachs
bracts105617773__bracts
braes75735053__bra_es
brakes124923123__brakes
braves115524083__braves
brazes175522193__brazes
cumbrances1844213cumbrances
earaches13411303e_araches
effaces15277273e_ffaces
emanates10311333emanates
embalms1335333emb_alms
embanks15295703emb_anks
embargoes1442903embargoes
embarked17205213embarked
embarks15337353emb_arks
embarred13174793embarred
embars103812883emb_a_rs
embayed1535443emb_ayed
embays131408333emb_a_ys
emblaze2045773emblaze_
emblazed2244743emblazed
emblazer2144563emblazer
emblazers2243703emblazers
embodies1337003embodies
embolies1239153embolies
embosses1235963embosses
embraceries1752863embraceries
embracing1645443embracing
embracive1843853embracive
embrangles1543213embrangles
embrasures1452713embrasures
embrocates1665013embrocates
embroils1245773embroils
embrowns1544043embrowns
embrue1036533embr_ue_
embrued1235293embr_ued
embrute1145703embrute_
embruted1344353embruted
embryons1574043embryons
embryos1464093embr_yos
emeerates1149373emeerates
emeralds1144593emeralds
emerges101310883emer_ges
emeries91620023emer_ies
emigrates1248583emigrates
emirate91015833emirate_
empales112411433em_pales
emphases1568353emphases
emplace1338263emplace_
emplaced1536043emplaced
emplanes1239503emplanes
emprises12311003emprises
emprizes2138133emprizes
emulates10312573emulates
enfaces122110913e_nfaces
enframes1357453enframes
engraves1237233engraves
enlaces92313393e_nlaces
enrages83114853e_nrages
entrances11310953entrances
erases64425403e__rases
extracts1747623extracts
graces94523493__graces
headraces1546613headraces
hyraces1537913_hyraces
imblazes2144723imblazes
imbrues1135503imbr_ues
imbrutes1244203imbrutes
librates103412953librates
maces97139963_m__aces
maracas11313773_maracas
membrane1445653membrane_
membraned1643903membraned
menaces112715523_menaces
merces105720743_mer_ces
miracles1238333_miracles
mirages102213533_mirages
morales93619403_morales
murices112612283_murices
ombres103911143ombr__es
outraces102217863outraces
races74943243___races
reembrace1544183reembrace_
reembraced1742953reembraced
rerebraces1445033rerebraces
retraces101417273retraces
rubaces1139313rub_aces
semblances1644213semblances
subrace11313003subrace_
terraces102712253terraces
thoraces13118943thoraces
traces85329933__traces
umbrae1038683umbra_e_
umbrage1236723umbrage_
umbras1038643umbra__s
unbrace111910483unbrace_
unbraced132310433unbraced
unbrakes14258413unbrakes
vambrace1743983vambrace_
vambraced1942403vambraced
vibrances1645763vibrances
vibrates132210613vibrates

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.1561145455.1
2DLD Change Limit1461621407.45319611.2
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.65523343.0
 
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.