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

162 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
beyliks163485(None) 
beylics1436181beylics
beylik1545881beylik_
bedlike14369532bedlike
beelike13379782beelike
belies84631052be_lies
belike124616282be_like
bellies94023722bellies
berlins93216012berlins
beylic1337822beyli_c
abelias93213563abe_lias
baglike14338943baglike
bailies94120203bailies
balks114926293b_al_ks
ballies93725743ballies
batiks1239373b_atiks
batlike133311883batlike
battiks1337143battiks
baulks12429373baul_ks
beadlike15137253beadlike
beaklike13155773beaklike
beaks115326623be__aks
beamlike16115843beamlike
beanies93821093beanies
beanlike14146843beanlike
bearlike14156793bearlike
beatniks1444043beatniks
becks135522013be__cks
becloaks1644933becloaks
beclogs1237073beclogs
bedecks1635793bedecks
bedims1149593be_dims
bedlams1237053bedlams
bedless1039703bedless
bedsits1037563bedsits
bedticks1774163bedticks
beduins1039123beduins
beedies10314203beedies
beeline93314723beeline
beelines103312803beelines
befits114711503be_fits
beflags1355493beflags
befleas1236973befleas
beflecks1943753beflecks
begins94415303be_gins
beglads11127263beglads
begrims1276763begrims
bekiss1236373be_kiss
belays114313853be_lays
belgas9311713be_lgas
belie75630383be_li_e
belied95022163be_lied
belief115018603be_lief
beliefs12448583be_liefs
belier84423563be_lier
beliers94617383be_liers
belive115415303be_live
belleeks1444363belleeks
belles85325993be_lles
bellied104314073bellied
belling103825073belling
bellings113811153bellings
bellows124313303bellows
bells76432163be_l_ls
bellylike1842843bellylike
belons84119413be_lons
belows114614183be_lows
bels66142493be_l__s
belts75931163be_l_ts
belying133612443belying
bemocks1735373bemocks
bennies93917313bennies
bennis84314803benni_s
benzins1838693benzins
berks115423123be__rks
berlin83116373berli_n
berline93716853berline
berlines102315453berlines
berries94423553berries
berrylike1842353berrylike
beryline1337083beryline
beryls11107883beryl__s
beslime1146833beslime
beslimes1246953beslimes
bestirs9311133bestirs
bethinks1765043bethinks
bevies114017303be_vies
bewails1277553bewails
bewigs1246533be_wigs
beyonds1335063beyonds
beys913829553bey___s
bezils1711310603be_zils
bialies93618413bialies
bialis83617163biali_s
biblike1536893biblike
bilks115117893b_il_ks
billies93923503billies
blinks124613573b__links
blips95615783b__lips
bliss75616913b__liss
bowlike16349473bowlike
boxlike20267073boxlike
boychiks2242933boychiks
boylas113011723boyl_as
budlike14257873budlike
bulks115920613b_ul_ks
bullies94121893bullies
byelaws1533263byelaws
bylaws14415833b_ylaws
byline11311643b_yline
bylines1239243b_ylines
ceilis85413743ceili_s
delis64928543de_li_s
dellies83622213dellies
doylies114512573doylies
eellike1138233eellike
elks85820033_e_l_ks
eyelids1135943_eyelids
eyelike1436973_eyelike
eyries93816813_eyries
felids103111623fe_lids
fellies104119743fellies
ferlies103216693ferlies
gemlike14206813gemlike
helios94816633he_lios
henlike1448693henlike
ivylike1734283ivylike
jellies143816533jellies
jetlike18276763jetlike
kelims1278913ke_lims
kellies113516853kellies
keyless1436163keyless
kliks8398823__kliks
kylikes1333583_kylikes
leglike12136843leglike
mealies92821933mealies
merlins93015813merlins
myelins1237353myelins
nellies73418723nellies
netlike11308913netlike
obelias9279033obe_lias
obelisk1345193obe_lisk
obelisks1443443obe_lisks
pealike131211273pealike
peglike14136773peglike
raylike14269253raylike
reflies104418533reflies
relics84517903re_lics
relies65036423re_lies
relinks114510223re_links
replies94521043replies
skylike1336103skylike
susliks1136443susliks
sylis84316023_syli_s
tealike111111083tealike
tellies73820503tellies
toylike14157243toylike
weblike1635923weblike
wellies103719073wellies
wheylike2143403wheylike
yeelins1038813yeelins
yelks126413623ye_l_ks

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 Limit1340271626.98319193.3
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.45223978.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.