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

298 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
beleaps113805(None) 
beleap10410281beleap_
beleapt11310251beleapt
becaps123811402be_caps
beeps95320972be_e_ps
befleas1236972beflea_s
beheads1338522beheads
belays114313852bel_ays
beldams1237052beldams
beleaped1336102beleaped
belgas9311712belga_s
bemeans1148742bemeans
beweeps1494562beweeps
bewraps14135402bewraps
bleaks125112432b_leaks
blears85116452b_lears
bleats85518612b_leats
bleeps10499102b_leeps
deleads9379702deleads
gelcaps1235202gelcaps
keleps12478812kele_ps
leaps75522932__leaps
upleaps1185232upleaps
abeles84719393abele__s
abelias93213563abelia_s
balas76937213bal_a_s
baleens938473baleens
balers85626933bale_rs
bales76250083bale__s
ballads104212913ballads
balsams11579013balsams
balsas86417523balsa_s
baps86040843b___aps
beads85429503b__eads
beaks115326623b__eaks
beams95328173b__eams
beans75734693b__eans
bears75739043b__ears
beats76042243b__eats
beaus75127113b__eaus
bebops1237623be_bops
becap114315053be_cap_
beclasp1335263beclasp
beclasps1444353beclasps
becloaks1644933becloaks
bedecks1635793bedecks
bedells10379363bedells
bedels94015273bede_ls
bedews12398943bede_ws
bedlamps1543663bedlamps
bedlams1237053bedlams
bedless1039703bedle_ss
bedpans1237173bedpans
bedrape1277693bedrape
bedrapes1386963bedrapes
beefs105618563be_e_fs
beep85931213be_e_p_
beers75628393be_e_rs
bees65453383be_e__s
beets76131443be_e_ts
beeves114615043be_eves
beflags1355493beflags
beflea1147123beflea__
befleaed1454663befleaed
beflecks1943753beflecks
begets96215523bege_ts
beggars11378223beggars
beglads11127263beglads
behead1239923behea_d
behests1235953behests
bejesus1643693bejesus
belady12489933bel_ady
belaud939133bel_aud
belauds1036643belauds
belay105021523bel_a_y
belches143514343belches
beldam11410113belda_m
beldame1237233beldame
beldames1336803beldames
beleaping1436743beleaping
belga8313233belga__
beliefs12448583beliefs
beliers94617383beliers
belies84631053bel_ies
believes13449403believes
belleeks1444363belleeks
belles85325993bel_les
bellhops1544873bellhops
bellies94023723bellies
bellows124313303bellows
bells76432163bel__ls
belongs10408223belongs
belons84119413bel_ons
belows114614183bel_ows
bels66142493bel___s
belters93819413belters
belts75931163bel__ts
beltways1683903beltways
belugas1035903belugas
bemas96424283be_ma_s
bemean10410683bemea_n
bemoans1138253bemoans
bendays13327513bendays
beneath1236973beneath
benempt1346263benempt
benes75536233bene__s
bereave1258353bereave
bereaves1338273bereaves
berets85822523bere_ts
beseems1175913beseems
beses75830723bese__s
besets85718803bese_ts
besmears1234543besmears
bespeaks1643963bespeaks
besteads11307123besteads
betas75528763be_ta_s
betels84515063bete_ls
betrays12127823betrays
bettas84913923betta_s
bevels113913983beve_ls
beweary1536223beweary
beweep13147253beweep_
bewept13410323bewe_pt
bewrap13157053bewrap_
bewrapt14147133bewrapt
bewrays15145113bewrays
bezels173712283beze_ls
bezoars1836793bezoars
biceps12447713bice_ps
biles75542143bile__s
bitmaps1344253bitmaps
blabs95619633b_l_abs
blahs105616513b_l_ahs
blams95023853b_l_ams
blats75132503b_l_ats
blaws105620463b_l_aws
bleach133611403b_leach
bleak115915383b_lea_k
blear75918683b_lea_r
bleary115112553b_leary
bleat75737003b_lea_t
blebs96416153b_le_bs
bleeds95211593b_leeds
bleep95013453b_leep_
blends96012883b_lends
bless75917813b_le_ss
blets75324943b_le_ts
blimps12588153b_limps
blips95615783b_l_ips
bloats85215763b_loats
bloops106611343b_loops
bluecaps1442513bluecaps
boheas114013213bohea_s
bolas74733763bol_a_s
boleros9310293boleros
boles75448603bole__s
boletes9316063boletes
boletus948643boletus
bopeeps1333103bopeeps
boreas85421733borea_s
breads95419203b_reads
breaks124816423b_reaks
breams104815043b_reams
bureaus979293bureaus
burlaps1156253burlaps
byelaws1533263byel_aws
bylaws14415833byl_aws
celebs1037883cele_bs
celiacs11157893celiacs
cellars93713693cellars
cereals9313173cereals
cheaps134613683_cheaps
claps95626183_cl_aps
cleans85817053_cleans
clears84116563_clears
cleats84919313_cleats
coleads102911423coleads
debeaks1436103debeaks
deeps84921773de_e_ps
defeats113511233defeats
defleas1147223deflea_s
delays104014053del_ays
delead84112343delea_d
deleave1147723deleave
deleaves1248063deleaves
deles65139253dele__s
deletes83117933deletes
deltas74414823delta_s
demeans1039723demeans
dewlaps1334663dewlaps
elans55527753_el_ans
elapse857523_el_apse
elects83315003_elects
elemis8312383_elemis
fellahs13428393fellahs
fellas95116963fella_s
flaps105621383_fl_aps
fleams115011943_fleams
fleas86423663_flea_s
galeas74618513galea_s
gelcap1136213gelcap_
gelees74116263gele_es
gleams94812253_gleams
gleans75014743_gleans
heaps105223223__heaps
heeltaps1343073heeltaps
helps105219343hel__ps
jalaps15299183jal_aps
jeeps144715373je_e_ps
juleps1535623jule_ps
keeps116020283ke_e_ps
kelep116014563kele_p_
kelps115116423kel__ps
laps66848873__l_aps
leads66028493__leads
leafs85721183__leafs
leaks95923913__leaks
leans55536253__leans
leap66032683__leap_
leapt75027473__leapt
lears55938733__lears
leas45954183__lea_s
melees83618083mele_es
melenas999203melenas
metepas1136303metepas
neaps75618323__neaps
neeps75617883ne_e_ps
obelias9279033obelia_s
outleaps10237073outleaps
overleaps14226783overleaps
peeps95822363pe_e_ps
peles75738083pele__s
perhaps1446123perhaps
petnaps1145033petnaps
pileups11365433pileups
pleads94613953_pleads
pleas75627033_plea_s
pleats85218593_pleats
queleas1636723quelea_s
reaps75626193__reaps
recaps103615733re_caps
recleans1037513recleans
redcaps1247073redcaps
redears82814453redears
regears83012463regears
rehears103312773rehears
reheats104513523reheats
relapse947703rel_apse
relays94316753rel_ays
relearn747973relearn
relearns836303relearns
release7312763release
releases8313343releases
relends84013253relends
relents74018503relents
relets64025673rele_ts
releves103914973releves
reloads8911313reloads
reloans7313133reloans
remaps105012873re_maps
repeals94014523repeals
repeats94316053repeats
repleads11357213repleads
rereads81512293rereads
reseals73917663reseals
reseats74319583reseats
reseaus74012153reseaus
reteams9339563reteams
retears72814923retears
reveals103812723reveals
rewears102911043rewears
rewraps12136563rewraps
saleps85014903sale_ps
seeps74828753se_e_ps
selahs9313213sel_ahs
selects91912143selects
selvas93812913selva_s
shlepps14394833shlepps
shleps114710333shle_ps
slaps76025713_sl_aps
sleeps83913323_sleeps
sneaps84510863_sneaps
teledus835093teledus
telegas837443telegas
telerans859473telerans
teles54536003tele__s
teleses7313123teleses
telesis7310793telesis
telexes1438353telexes
threaps12488643threaps
unleads8228623unleads
upheaps1494233upheaps
upleap10106843upleap_
upleapt11116863upleapt
veeps104715723ve_e_ps
velars93913723vel_ars
weeps104120563we_e_ps
yelps105712993yel__ps

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.406440125.6
2DLD Change Limit1340272986.23621492.5
3Display Results2982980.1062811.3
 (SQL Overall)1786912986.74826480.6
 
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.