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

104 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
becharm163684(None) 
becharms1745341becharms
becalm1239202bec_alm
bechalk1845802bechalk
becharmed1944662becharmed
beswarm1445782beswarm
brecham1646832brecha_m
charm126124662__charm
echard1249222_echard
rechart12314332rechart
baccara1347143baccara
barm86739603b___arm
beam86939233be__a_m
bear66844643be__ar_
beard86024963be__ard
bears75739043be__ars
becalms1335743bec_alms
became123213163bec_ame
becap114315053bec_a_p
becaps123811403bec_aps
bechalks1944793bechalks
bechamel1754283bechamel
bechance1747743bechance
becharming2044303becharming
beclasp1335263beclasp
becoward1644763becoward
becrawl1444583becrawl
bedchair1642793bedchair
bedchairs1742603bedchairs
bedlam1149273bedla_m
bedward1497473bedward
bedwarf16106463bedwarf
beeyard1335523beeyard
beggar10328223beggar_
beggars11378223beggars
beggary14316153beggary
behalf14310953be_half
behave14209013be_have
belcher143511493belcher_
belchers153510023belchers
beldam11410113belda_m
bencher144113483bencher_
benchers153611013benchers
benchmark2252053benchmark
berm86732753be___rm
beshame1447483beshame
beswarms1544323beswarms
bethank1666273bethank
bethorn1238643bethorn
beware11313713be_ware
beweary1536223beweary
beworm1339993be_worm
bezoar1736913bezoar_
bezoars1836793bezoars
bicarb1238543bic_arb
bioherm1434653bioherm
brechams1745773brechams
brechan1437223brecha_n
brechans1547413brechans
buckram1746113buckram
cham115532313__cha_m
char95132153__char_
chard116124743__chard
chare105231983__chare
chark144222713__chark
charms135218843__charms
charr104821783__charr
chars105936643__chars
chart105038283__chart
chary135023133__chary
chasm125518793__chasm
chirm125317063__chirm
decare93919153dec_are
deciare10710663deciare
declaim1247363declaim
declare10411223declare
echards1337963_echards
eschar1136533eschar_
eschars1237183eschars
harm95637793___harm
hectare1238463hectare
lechayim1842263lechayim
lecher113415853lecher_
lechers123313963lechers
lechery15257643lechery
nectar838853nectar_
nectars938463nectars
nectary1246223nectary
orchard1346933orchard
outcharm1544733outcharm
peccary1636283peccary
pechan13511543pecha_n
pechans14810503pechans
pochard1537363pochard
rearm75923573re__arm
recharge1476613recharge
recharts1337663recharts
reclaim1137753reclaim
rewarm115913493re_warm
secpar1037923secpar_
secpars1138413secpars
sectary1238273sectary
tharm105916643__tharm
unchary1537263unchary

Search took 8 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 Limit1340271046.71619956.4
3Display Results1041040.0333151.5
 (SQL Overall)1786911047.15524974.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.