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

126 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
beleapt1131025(None) 
beleap10410281beleap_
beleaps1138051beleaps
beleaped1336102beleaped
benempt1346262benempt
bewept13410322bewe_pt
bewrapt14147132bewrapt
bleat75737002b_lea_t
leapt75027472__leapt
upleapt11116862upleapt
ballast9313993ballast
beast76338643b__east
beat66168303b__ea_t
beaut75135213b__eaut
becap114315053be_cap_
becaps123811403be_caps
bedfast1346413bedfast
bedrape1277693bedrape
beep85931213be_e_p_
beeps95320973be_e_ps
beet66457543be_e__t
beflea1147123beflea__
befleaed1454663befleaed
befleas1236973beflea_s
begat86629723be_ga_t
beget85632563bege__t
behead1239923behea_d
beheads1338523beheads
behest11314613behe_st
belady12489933bel_ady
belaud939133bel_aud
belay105021523bel_a_y
belays114313853bel_ays
beldam11410113belda_m
beldame1237233beldame
beldams1237053beldams
beleaping1436743beleaping
belga8313233belga__
belgas9311713belga_s
belt65754033bel___t
bemean10410683bemea_n
bemeans1148743bemeans
beneath1236973beneath
benefit1248073benefit
bereave1258353bereave
bereft114317303bere_ft
beret74946363bere__t
beset76739133bese__t
beweary1536223beweary
beweep13147253beweep_
beweeps1494563beweeps
bewrap13157053bewrap_
bewraps14135403bewraps
bezant17814543be_zant
bezzant1746893bezzant
blast76532573b_l_ast
blat66550953b_l_a_t
bleach133611403b_leach
bleak115915383b_lea_k
bleaks125112433b_leaks
blear75918683b_lea_r
blears85116453b_lears
bleary115112553b_leary
bleats85518623b_leats
bleep95013453b_leep_
bleeps10499103b_leeps
blent76230953b_le_nt
blest76431723b_le_st
blet66247673b_le__t
bloat75229923b_loa_t
breast8319643b_reast
clapt98027173_cl_apt
cleat76335063_clea_t
clept95725773_cle_pt
defeat103817163defea_t
delead84112343delea_d
deleads9379703deleads
deleave1147723deleave
elect74327033_ele_ct
elegant8311503_elegant
elegit71212893_elegit
eluant6315093_eluant
enrapt8313013_enrapt
exempt1737453_exempt
fleapit1255993_fleapit
gelant72821673gel_ant
gelcap1136213gelcap_
gelcaps1235203gelcaps
gellant83214053gellant
heliast10312073heliast
hereat93527413herea_t
kelep116014563kele_p_
keleps12478813kele_ps
leant56737783__leant
leap66032683__leap_
leaps75522933__leaps
least56134883__least
lept66440883__le_pt
outleapt10318153outleapt
overleapt14247883overleapt
peltast9310513peltast
periapt11313413periapt
pleat74734473_plea_t
readapt1039743readapt
receipt1159253receipt
recept103319083rece_pt
reheat94423943rehea_t
relearn747973relearn
relearnt849213relearnt
release7312763release
relent64431853rele_nt
relet54749823rele__t
relevant1149243relevant
reliant7319243reliant
repeat85127213repea_t
reseat64131493resea_t
rewrapt12138113rewrapt
sejeant1489723sejeant
select82621173sele_ct
slept75728103_sle_pt
telecast1048303telecast
teleost7410523teleost
telepath1345143telepath
upleap10106843upleap_
upleaps1185233upleaps
yclept1336013ycle_pt

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.406440125.6
2DLD Change Limit1340271267.95316852.4
3Display Results1261260.0462739.1
 (SQL Overall)1786911268.40521260.1
 
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.