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

113 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
beclasp133526(None) 
beclasps1444351beclasps
reclasp1136641reclasp
becap114315052bec_a_p
becaps123811402bec_aps
beclasped1643742beclasped
bedlamp1464512bedlamp
clasp95517192__clasp
declass1038732declass
enclasp1145842enclasp
inclasp1145302inclasp
reclasps1235052reclasps
tieclasp1242802tieclasp
unclasp1135962unclasp
backlash1945923backlash
balas76937213b_alas_
ballast9313993ballast
beast76338643be__ast
becalm1239203bec_alm
becalms1335743becalms
became123213163bec_ame
because1136233because
bechalk1845803bechalk
becharm1636843becharm
becks135522013bec_ks_
beclamor1484303beclamor
beclasping17134073beclasping
becloak1545043becloak
becloaks1644933becloaks
beclog1136863becl_og
beclogs1237073beclogs
becloud1246293becloud
beclown1435423beclown
becrawl1444583becrawl
becrust1137983becrust
becurse1136183becurse
becurst1147853becurst
bedfast1346413bedfast
bedlam1149273bedla_m
bedlamps1543663bedlamps
bedlams1237053bedlams
bedless1039703bedless
beflag1265883befla_g
beflags1355493beflags
befleas1236973befleas_
beglad10138463begla_d
beglads11127263beglads
belady12489933be_lady
belaud939133be_laud
belay105021523be_la_y
belays114313853be_lays
beleap10410283be_leap
beleaps1138053beleaps
belgas9311713belgas_
belles85325993belles_
bellhop1445053bellhop
bells76432163be_lls_
bels66142493be_l_s_
belts75931163be_lts_
bemas96424283be_mas_
betas75528763be_tas_
bettas84913923bettas_
bewrap13157053bewra_p
bewraps14135403bewraps
blase75524233b__lase
blast76532573b__last
bolas74733763b_olas_
boylas113011723boylas_
burlap1098353burla_p
burlaps1156253burlaps
clamp115517653__clamp
clap86429043__cla_p
claps95626183__claps
clash106219033__clash
clasps104512093__clasps
claspt104513413__claspt
class75525483__class
clast76030583__clast
cyclase1436613cyclase
decals93717713decals_
decamp1338453dec_amp
decease1049523decease
declaim1247363declaim
declare10411223declare
declasse1165943declasse
declaw1266703decla_w
declaws1336253declaws
dewlap1264843dewla_p
dewlaps1334663dewlaps
eclair836813_eclair
eclat7523603_ecla_t
eclats8313033_eclats
enclasps1245133enclasps
euclase938933euclase
fellas95116963fellas_
gelcap1136213gelca_p
gelcaps1235203gelcaps
inclasps1244353inclasps
meccas1239493meccas_
pectase112410363pectase
recap95718023rec_a_p
recaps103615733rec_aps
recast83422773rec_ast
reclad9311873recla_d
reclads1049993reclads
reclaim1137753reclaim
reclame11411063reclame
reclasped1444863reclasped
recluse95210773recluse
teslas64212173teslas_
tieclasps1342213tieclasps
unclamp1344993unclamp
unclasps1244573unclasps

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 Limit1340271136.10621950.0
3Display Results1131130.0333424.2
 (SQL Overall)1786911136.54527301.9
 
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.