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

139 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
ravellers1225716(None) 
ravelers113310861rave_lers
raveller11339261raveller_
revellers12319501revellers
travellers1364661travellers
bevellers14276112bevellers
cavillers1435612cavillers
drivellers1452952drivellers
grovellers1443322grovellers
labellers11206552labellers
levellers12286042levellers
raveler104212462rave_ler_
ravelled12419782ravelle_d
raveners11309122rave_ners
repellers11278872repellers
resellers9299902resellers
revealers12318242revealers
revelers113414132reve_lers
reveller112912182reveller_
travelers12266772trave_lers
traveller1266602traveller_
ateliers837883_ateliers
avengers1235583_avengers
averters11249513_averters
ballers94421013ba__llers
bevelers13389453beve_lers
beveller13387663beveller_
braillers1135553bra_illers
cadelles1139973cadelle_s
callers94221963ca__llers
cameleers1345093cameleers
canallers1137213canallers
cancellers1445363cancellers
caravelles1544883caravelle_s
carollers1137703carollers
cavaliers1455613cavaliers
cavilers1348113cav_ilers
caviller1337063caviller_
cupellers1374863cupellers
drivelers1364223drive_lers
driveller1353853driveller_
duellers9268223_duellers
dwellers12356083_dwellers
enamellers1242763enamellers
expellers18104743expellers
fallers103917993fa__llers
favellas1446163favell_as
fellers104117543__fellers
frivollers1642073frivollers
fuellers11277983_fuellers
gabelles11278933gabelle_s
gaseliers1044923gaseliers
gavelled13387363gavelle_d
gazelles18266563gazelle_s
graveless13226693grave_less
gravelled1475553gravelle_d
grovelers13305163grove_lers
groveller1354233groveller_
gruellers1034183gruellers
hellers103619833__hellers
impellers1345103impellers
jewellers1943533jewellers
labelers10249413labe_lers
labeller10248073labeller_
lavaliers1254283lavaliers
laveers10329363lave__ers
lavenders1334753lavenders
levelers11259323leve_lers
leveller11317593leveller_
libellers11236033libellers
marcellers1443833marcellers
modellers1245393modellers
nacelles1048393nacelle_s
propellers1455203propellers
quellers17237533_quellers
rabblers123810853ra_bblers
rafflers14317363ra_fflers
railers74420663ra__ilers
raillery1134953ra_illery
ralliers84010833ra_lliers
ramblers124010373ra_mblers
rarefiers1244023rarefiers
rattlers83510293ra_ttlers
ravagers1235573rav_agers
raveled114113633rave_le_d
ravelings13377383ravelings
ravelins113011603rave_lins
ravelling13269243ravelling
ravellings14214453ravellings
ravelly13268353ravell__y
ravelment1447203ravelment
ravelments1545193ravelments
ravels94717073rave_l__s
ravener104110733rave_ner_
ravers94628183rav___ers
ravishers1564783ravishers
recallers1137103recallers
reelers73520273r__eelers
reliers75519213r__eliers
repealers11278843repealers
repeller103010393repeller_
rerollers9207123rerollers
reseller83412223reseller_
revealer113110073revealer_
reveilles1245203reveille_s
reveler104116343reve_ler_
revelled123712733revelle_d
revengers1336413revengers
revenuers1235983revenuers
reverers113113153reve_rers
reversers12298483reversers
reverters122710433reverters
revilers114011693rev_ilers
revolters12297483revolters
revolvers15286113revolvers
riverless1244943riverless
riveters11228163rive_ters
rollers73117473r__ollers
roselles8310713roselle_s
sellers73721313__sellers
shellers112812573_shellers
shovellers16173783shovellers
smellers10329763_smellers
snivellers1352873snivellers
spellers102812753_spellers
taverners1244273taverners
teasellers1043953teasellers
tellers73717593__tellers
traveler11328433trave_ler_
travelled1356863travelle_d
traversers13113293traversers
trowellers1343663trowellers
vealers103214293__vealers
veilers103911823__veilers
waveless1437483wave_less
wavelets1436153wave_lets
waverers14318613wave_rers
yellers103912953__yellers
yodellers1343973yodellers

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411396.31323545.2
3Display Results1391390.0632206.3
 (SQL Overall)1786911396.53227356.2
 
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.