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

143 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
rivulet106972(None) 
rivulets1174751rivulets
riblet84222442ri_blet
rillet64828852ri_llet
ringlet82818172ringlet
ripplet113412582ripplet
rivaled1138932rivaled
rivet85636362riv__et
aiglet74224193ai_glet
amulet8419573_amulet
annulet7311593annulet
billet86029723bi_llet
bivalent1346123bivalent
briquet1838833briqu_et
circlet11311473circlet
civet105828733civ__et
culet76040343__culet
divalent1247783divalent
divulge1243103divulge
divulged1442963divulged
divulger1342553divulger
divulges1343603divulges
divulse1134913divulse
divulsed1343883divulsed
divulses1244763divulses
dribblet13347543dribblet
driblet103712243dri_blet
driveled1374973driveled
driveler1284693driveler
epaulet939513epaulet
filet85540163fi__let
fillet95027083fi_llet
frivoled1534043frivoled
frivoler1443933frivoler
giblet93418893gi_blet
giglet83920273gi_glet
gimlet93716663gi_mlet
grivet103517823griv__et
inlet53732403_i_nlet
islet54527553_i_slet
kinglet123114043kinglet
ligule74010833ligule_
ligules82210923ligules
miauled1036663miauled
millet84030743mi_llet
minuet82621033minu_et
miquelet1944473miquelet
ovule839493_ovule_
ovules938223_ovules
piglet93420923pi_glet
pilule8411123pilule_
pilules9510623pilules
piolet83225643pi_olet
piquet17412353piqu_et
privet113821343priv__et
raveled114113633raveled
raveler104212463raveler
reflet94024233r_eflet
reglet73724233r_eglet
relet54749823r__elet
result6318223resul_t
reveled113917753reveled
reveler104116343reveler
revet84938843rev__et
revile94921613revile_
reviled114417923reviled
reviler104314973reviler
reviles104421353reviles
revolt9316223revol_t
revue81114453revu_e_
revues9813903revu_es
revuist1038473revuist
revulsed1235443revulsed
riblets93412553ri_blets
riddle83915713riddle_
riddled103012043riddled
riddler93411263riddler
riddles93215023riddles
ridley10169543ri_dley
riffle124210233riffle_
riffled14338603riffled
riffler13328353riffler
riffles133911163riffles
rifle85518333ri_fle_
rifled104115003ri_fled
rifler94014263ri_fler
rifles94217703ri_fles
rile45650533ri__le_
riled65833253ri__led
riles55343643ri__les
riley84420583ri__ley
rille55728733ri_lle_
rilled74525653ri_lled
rilles64725503ri_lles
rillets74216153ri_llets
rimple103814583rimple_
rimpled123311423rimpled
rimples113114223rimples
ringlets92910233ringlets
ripple103413913ripple_
rippled123110273rippled
rippler113210103rippler
ripples113513293ripples
ripplets12316733ripplets
risuses73210923risuses
rivage1038843rivage_
rivages1138873rivages
rival85216503rival__
rivalled1236093rivalled
rivalry1354033rivalry
rivals94213183rival_s
rive75537723riv__e_
rived94825613riv__ed
riven85121623riv__en
river85731693riv__er
rives85336003riv__es
riveted11258573riveted
riveter10208753riveter
rivets94417113riv__ets
rivulose1143363rivulose
rootlet73015733rootlet
roquet154415893roqu_et
roupet84218343r_oupet
rule49938423r__ule_
ruled65822523r__uled
ruler54923343r__uler
rules55234253r__ules
rundlet83114153rundlet
runlet63821413r_unlet
singlet84120113singlet
triolet73219523tri_olet
triplet94319213tri_plet
trivalent1246483trivalent
trivet93721883triv__et
valet84337873__valet
veinulet1147393veinulet
violet92620923vi_olet
virulent1146433virulent
wavelet13310943wavelet
wiglet105519153wi_glet
willet95124833wi_llet
winglet113115983winglet
wristlet1138643wristlet

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 Limit1340271436.57620381.2
3Display Results1431430.0502860.0
 (SQL Overall)1786911437.03225411.1
 
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.