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

158 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
embarks1533735(None) 
embanks15295701embanks
embark14458521embark_
embars103812881embar_s
imbarks15326611imbarks
ambaris113112162ambaris
barks115735812__barks
debarks14388492debarks
demarks14339232dem_arks
embalms1335332embalms
embank14346552embank_
embar94011602embar__
embargo1243022embargo
embarked17205212embarked
embays131408332emba_ys
embers104116182ember_s
embosks1594462embosks
imbark14347862imbark_
imparks15276662imparks
marks115933482_m_arks
reembarks1743482reembarks
remarks13329982rem_arks
ambages1269623ambages
ambari103012173ambar_i
ambaries123312383ambaries
ambary134010543ambar_y
ambers104519583amber_s
arks85936873___arks
backs135729623__backs
balks114926293__balks
banks115527903__banks
barbs95928193__barbs
bards87139643__bards
bares75457133__bares
barfs104826003__barfs
bark106242153__bark_
barky145721613__barky
barms96128463__barms
barns76335143__barns
bars66564093__bar_s
basks115621763__basks
berks115423123__berks
birks114920303__birks
bombards1536493bombards
borks115727703__borks
carks115534213__carks
cembalos14135163cembalos
charks155219703_charks
darks106727873__darks
debark134210943debark_
debars94218043debar_s
demark134211023dem_ark_
disembarks1953123disembarks
earls56127513e__arls
earmarks1444793earmarks
earns55927563e__arns
ears46356593e__ar_s
ebooks12358333e_books
echards1337963echards
eggars8398973eggar_s
emails84412343em_ails
embalm1236653emba_lm
embanked17253883embanked
embargoes1442903embargoes
embarking1844193embarking
embarrass1342273embarrass
embarred13174793embarred
embassy1442703embassy
embay123410603emba__y
embayed1535443embayed
embeds11377903emb_eds
ember95516803ember__
emblazes2135673emblazes
emblems1335043emblems
embolus1135543embolus
embosk1464863embosk_
emboss1087383emb_oss
embows1396823emb_ows
embrace1388893embrace
embraces14128873embraces
embrue1036533emb_rue
embrues1136473embrues
embryo1363963emb_ryo
embryos1464093embryos
emeers83314183emeer_s
emigres1037673emigres
emirs76116163em_ir_s
emmers104013223emmer_s
empales112411433empales
empires1139853empires
escarps11397373escarps
escars83913133escar_s
eskars10357593eskar_s
eyebars1245333eyebar_s
harks126333433__harks
imbalms1334553imbalms
imbarked17254063imbarked
impark14287073impark_
imparts11298533imparts
kabars124513953kabar_s
kbars114612603_kbar_s
kebars124112493kebar_s
larks95227813__larks
lumbars11289763lumbar_s
maars74621633_maar_s
macks135127603_m_acks
maras75443293_m_aras
marcs95726623_m_arcs
mares76457633_m_ares
mark105138063_m_ark_
marka114620793_m_arka
markas124717003_m_arkas
marls75535163_m_arls
mars66261873_m_ar_s
marts77442233_m_arts
masks115320533_m_asks
mbiras1077153_mbiras
members13258603member_s
merks114722403_m_erks
mimbars1397383mimbar_s
mirks115122143_m_irks
murks114821733_m_urks
narks96026033__narks
ombers104214403omber_s
ombres103911143omb_res
outbarks1437833outbarks
parks116134463__parks
quarks193810913_quarks
rebars84019833rebar_s
reembark1643883reembark_
remark123512373rem_ark_
reparks13249513reparks
sambars115113843sambar_s
sarks96632463__sarks
seamarks1445303seamarks
setbacks1686303setbacks
sharks135019723_sharks
smacks144112323sm_acks
smarms105712533sm_arms
smarts86218003sm_arts
smears84714433smear_s
smerks12449713sm_erks
smirks124910123sm_irks
snarks104815733_snarks
sparks124616363_sparks
squarks20417183squarks
tabards10310383tabards
tambaks15218153tamba_ks
tanbarks1445563tanbarks
tombacks18216463tombacks
tombaks15246863tomba_ks
umbers104215213umber_s
umbras1038643umb_ras
umiacks1534013umiacks
umiaks1244953umia_ks
unbars82113033unbar_s
warks127932403__warks
wetbacks1974983wetbacks

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.390458182.1
2DLD Change Limit1340271586.40620922.1
3Display Results1581580.0632507.9
 (SQL Overall)1786911586.85926052.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.