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 “bevies” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
bevies11401730(None) 
belies84631051belies
levies93919861levies
aeries64737782aeries
babies106123652babies
beanies93821092beanies
bedims1149592bedims
beedies10314202beedies
bees65453382be__es
beeves114615042beeves
befits114711502befits
begins94415302begins
beiges91014402beiges
bekiss1236372bekiss
belie75630382belie_
belied95022162belied
belief115018602belief
beliefs12448582beliefs
belier84423562belier
beliers94617382beliers
belles85325992belles
bellies94023722bellies
bemires113212832bemires
bemixes18338652bemixes
benes75536232be_nes
bennes86019012bennes
bennies93917312bennies
berimes115216642berimes
bermes106023002bermes
berries94423552berries
beses75830722be_ses
besides104814532besides
betides104915262betides
betimes115114412betimes
betise85616272betise
betises94816122betises
bevel104517042bev_el
bevels113913982bevels
bevors111610342bevors
bewigs1246532bewigs
bezils1711310602bezils
bikies124515162bikies
bodies94524142bodies
bogies94724312bogies
bovids1287972bovids
bovines12412662bovines
breves115516422brev_es
brevier1237762brevier
breviers1335922breviers
bries74942152b_ries
buries84633272buries
busies85525262busies
cavies114525002cavies
chevies153511442chevies
civies114116442civies
davies105020512davies
defies104624052defies
demies94825802demies
denies74729642denies
devices133212582devices
devils104412812devils
devise104215752devise
devises114116762devises
dexies145018342dexies
envies9314052envies
eves76230462_ev_es
evils84114262_evils
evites94916472_evites
genies75324942genies
heavies132713872heavies
ivies84215762_ivies
kevils13358332kevils
levees93714522levees
levied104111432levied
levier94013872levier
leviers103510342leviers
levins94514652levins
levis85818552levi_s
mavies114923192mavies
movies115118452movies
navies95218622navies
neves87021872nev_es
newies91014072newies
peavies122213402peavies
reives95723042reives
relies65036422relies
reties65436192reties
review1238692review
reviews1335532reviews
reviles104421352reviles
revise94019742revise
revises104220532revises
revives134715542revives
revues9813902revues
series64540972series
vegies104314272vegies
vies75238622__vies
wavies125019842wavies

Search took 3 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 Filter178691825510.1401276364.3
2DLD Change Limit82551982.51632810.4
3Display Results98980.0332969.7
 (SQL Overall)178691982.68966452.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.