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

127 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
beryline133708(None) 
berline93716851ber_line
beeline93314722be_eline
beltline1036942beltline
berlin83116372ber_lin_
berlines102315452ber_lines
berlins93216012ber_lins
berrylike1842352berrylike
byline11311642b__yline
terylene1144152terylene
aerolite8315053aerolite
airline7315033air_line
baculine1238983baculine
balkline1437973balkline
barnlike1437183barnlike
barytone1356023barytone
baseline10310753baseline
beadlike15137253beadlike
beaklike13155773beaklike
beamlike16115843beamlike
beanlike14146843beanlike
bearlike14156793bearlike
bedlike14369533be_dlike
beelike13379783be_elike
beelined11277713be_elined
beelines103312803be_elines
beetling1139283beetling
beguine1068503be_guine
belie75630383be__li_e
belike124616283be__like
belive115415303be__live
belling103825073be_lling
bellying14359073bellying
bellylike1842843bellylike
beltlines1135963beltlines
belying133612443bely_ing
bengaline1245633bengaline
benzine1839343be_nzine
beraking153612973beraking
berating113220763berating
berberine1346523berberine
berhyming2042713berhyming
berime105317333ber__ime
beriming13310463beriming
berming123614833ber_ming
berrying14137383berrying
berthing14209603berthing
beryl101211673beryl___
beryllium1651923beryllium
beryls11107883beryl__s
beslime1146833be_slime
betaine9413783be_taine
beveling143011033beveling
beylic1337823be_yli_c
beylics1436183be_ylics
beylik1545883be_yli_k
beyliks1634853be_yliks
birdlife1443483birdlife
birdlike1535233birdlike
birdlime1343563birdlime
birling104317053bir_ling
blueline1036873blueline
bowline123613113b_owline
breadline1246273breadline
brine75132273b_r__ine
bromine112915243b_romine
brucine1138273b_rucine
bubaline1247163bubaline
buntline10198063buntline
burbling13249423burbling
burgling12239303burgling
burling104421133bur_ling
burying133413913bury_ing
bustline10208843bustline
butylene1344403butylene
bylined1335853b__ylined
byliner1235723b__yliner
bylines1239243b__ylines
byrling13337373byr_ling
carline93923623car_line
cervine122610803cer_vine
deadline10139053deadline
decline103716613de_cline
ermine8416923_er_mine
errhine1036593_errhine
feline94820143fe__line
ferine96422583fer__ine
ferlie92814053fer_li_e
fernlike1535243fernlike
feruling1258873feruling
germlike1535093germlike
guyline11258173_guyline
hardline12310273hardline
headline12129613headline
hemline12311073he_mline
herblike1735883herblike
herdlike1636113herdlike
heroine103517493her_oine
kerosine1238153kerosine
marline93320973mar_line
merlin83916683mer_lin_
merlins93015813mer_lins
neckline1496363neckline
nervine102510633ner_vine
pargyline1544653pargyline
pemoline12310273pemoline
percaline13410953percaline
periling11316863periling
perilune1046993perilune
perlite9317323per_lite
petaline10314883petaline
praline93019743_praline
proline92321593_proline
purline93516533pur_line
recline94020493re_cline
redline84218833re_dline
reguline939503reguline
reline65434353__reline
sepaline10311343sepaline
serflike1536273serflike
serine65432673ser__ine
serotine8313573serotine
setline7313923se_tline
skyline1436793_skyline
terrine72517573ter_rine
terylenes1244933terylenes
versine102515173ver_sine

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621277.04620744.0
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.51523777.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.