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

131 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
embanks1529570(None) 
embank14346551embank_
embarks15337351embarks
banks115527902__banks
embalms1335332embalms
embanked17253882embanked
embark14458522embark_
embars103812882emba_rs
embays131408332emba_ys
embosks1594462embosks
imbarks15326612imbarks
ambages1269623ambages
ambaris113112163ambaris
ambones11312683ambones
armbands1355143armbands
backs135729623__backs
balks114926293__balks
bands85233423__bands
banes74945583__banes
bangs85627773__bangs
bank105835753__bank_
banns75321233__banns
bans66555143__ban_s
barks115735813__barks
basks115621763__basks
bemeans1148743bemean_s
bemoans1138253bemoan_s
bethanks1765313bethanks
blanks124112893_blanks
bonks116326463__bonks
branks124817383_branks
bunks115125083__bunks
cabanas112413033cabanas
cembalos14135163cembalos
clanks124615183_clanks
cranks125015313_cranks
cutbanks1644313cutbanks
debarks14388493debarks
debunks1433763debunks
demands114311413dem_ands
demarks14339233dem_arks
demeans1039723demean_s
ebons74316093e_bon_s
ebooks12358333e_books
elands74914773e_lands
elans55527753e_lan_s
eluants737583eluants
emails84412343em_ails
embalm1236653emba_lm
embanking1843813embanking
embar94011603emba__r
embargo1243023embargo
embarked17205213embarked
embassy1442703embassy
embay123410603emba__y
embayed1535443embayed
embeds11377903emb_eds
embers104116183emb_ers
emblazes2135673emblazes
emblems1335043emblems
embolus1135543embolus
embosk1464863embosk_
emboss1087383emb_oss
embows1396823emb_ows
embraces14128873embraces
embrues1136473embrues
embryos1464093embryos
emends95711433em_ends
empales112411433empales
empanel1145963empanel
empanels1244823empanels
emplanes1239503emplanes
errands847603errands
errants7410643errants
ethanes103713513ethanes
expands17195733expands
flanks133913403_flanks
franks134912733_franks
gobangs11385833gobangs
gobans94412043goban_s
hanks126226863__hanks
henbanes1336573henbanes
imbalms1334553imbalms
imbark14347863imbark_
imparks15276663imparks
lemans85316393lem_an_s
macks135127603_m_acks
manas76240433_m_anas
manes76648963_m_anes
manos74933623_m_anos
mans66354553_m_an_s
manus75924933_m_anus
marks115933483_m_arks
masks115320533_m_asks
means75831233_mean_s
membranes1545563membranes
minks115829273_m_inks
moans74624373_moan_s
monks116123393_m_onks
nonbanks1445033nonbanks
pembinas1454143pembinas
planks124116753_planks
pranks124814723_pranks
ranks95225733__ranks
reembarks1743483reembarks
remands104914883rem_ands
remans84823003rem_an_s
remarks13329983rem_arks
remnants1036843remnants
ribands10208393ribands
robands10219863robands
setbacks1686303setbacks
shanks135315583_shanks
skanks94710833_skanks
smacks144112323sm_acks
spanks124514123_spanks
stanks104917703_stanks
swanks134811563_swanks
tambaks15218153tamba_ks
tanks94624733__tanks
thanks134313133_thanks
tombacks18216463tombacks
tombaks15246863tomba_ks
tranks104017763_tranks
umbones1138013umbones
umiacks1534013umiacks
umiaks1244953umia_ks
unbans81912623unban_s
wanks126124483__wanks
wetbacks1974983wetbacks
yanks125316573__yanks

Search took 9 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.436409841.7
2DLD Change Limit1340271317.72017361.0
3Display Results1311310.0462847.8
 (SQL Overall)1786911318.20221786.3
 
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.