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

170 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
rivetted1222609(None) 
revetted122210941revetted
riveted11258571rive_ted
brevetted1543862brevetted
diverted13199582diverted
divested13268212divested
pipetted1335262pipetted
retted74826312r__etted
reverted122714712reverted
revested122612242revested
rewetted12228352rewetted
riverbed14245142riverbed
riveter10208752rive_ter
vetted104316322__vetted
abetted1058323_abetted
advected1534533advected
adverted1336103adverted
ariette7312373ari_ette_
ariettes8411353ari_ettes
averted112211613_averted
betted94721163__betted
bisected1336203bisected
bitted94418483bi__tted
breveted1435623breve_ted
briquetted2262403briquetted
caveated1439133caveated
coveted133011523cove_ted
curetted1137173curetted
curvetted1543703curvetted
cuvette1235833cuvette_
cuvettes1335323cuvettes
devested13239133devested
dieted83115493di_e_ted
digested11208163digested
dinette8310013dinette_
dinettes9310193dinettes
dipnetted1343353dipnetted
directed1238233directed
diverged14256883diverged
diverter12238623diverter
driveled1374973drive_led
drivelled1443983drivelled
duetted937023_duetted
everted112711853_everted
facetted1445743facetted
fetted104817893__fetted
fileted1159093file_ted
fitted104716663fi__tted
foveated1536293foveated
fretted113411853_fretted
frisette1195483frisette_
frisettes1295353frisettes
fritted113611333fri__tted
frizette2093503frizette_
frizettes2193493frizettes
gavotted1363343gavotted
gazetted19234853gazetted
gibbetted1542213gibbetted
gitted84015053gi__tted
grisette994653grisette_
grisettes1094713grisettes
gritted94110903gri__tted
ideated9310973_ideated
insetted9249023insetted
invected14258883invected
invented122510663invented
inverted122312163inverted
invested12229693invested
jetted143915083__jetted
kitted115114833ki__tted
letted74118543__letted
lineated9711063lineated
livened11238933live_ned
livered113111633live_red
liveried1238733liveried
navette1036983navette_
navettes1136613navettes
netted74118713__netted
obverted1435103obverted
oriented937483ori_ented
petted94121523__petted
pileated112711133pileated
pipette1137943pipette_
pipettes1237563pipettes
pitted94319593pi__tted
pivoted1336513piv_oted
prevented1539003prevented
priested1138393pri_ested
ratted74923343r__atted
raveled114113633rave_led
ravelled12419783ravelled
ravened115012283rave_ned
rebutted11126783rebutted
reested82916233r_eested
refected142311663refected
refitted12309413refitted
regretted1137233regretted
reheated122415003reheated
reinvented1445133reinvented
reinvested1444793reinvested
rejected182710113rejected
relented92614943relented
reletter81311023reletter
remelted11310153remelted
remitted113312073remitted
renested92212953renested
rented74426593r__ented
repeated113117443repeated
repented112614983repented
repotted1139283repotted
rerented92516163rerented
reseated93220263reseated
resected112514743resected
resented92716963resented
resetter81511833resetter
resettled1035303resettled
rested74430783r__ested
retested92212533retested
retied75924983r__etied
revealed123211213revealed
reveled113917753reve_led
revelled123712743revelled
revenged1337553revenged
revenued1237223revenued
reverbed14269223reverbed
revered112819333reve_red
reversed122711613reversed
reverter114812873reverter
revolted12319863revolted
revoted114314153rev_oted
rifted104115313ri__fted
righted122912143ri_ghted
rillettes946533rillettes
rimester1037813rimester
rioted73416373ri__oted
ripened1038203ripe_ned
riposted11216933riposted
ritter63822423ri__tter
rivaled1138933riv_aled
rivalled1236093rivalled
rived94825613riv___ed
riverbeds15243073riverbeds
riverhead1642993riverhead
riverweed1643053riverweed
rivet85636363rive_t__
riveters11228163riveters
riveting12139443riveting
rivets94417113rive_t_s
rivetting13256413rivetting
rosette7310373rosette_
rosettes8310343rosettes
rotted74524433r__otted
rouletted1045053rouletted
rutted74518403r__utted
stetted82610403_stetted
trisected1244913trisected
unletted9310313unletted
unvested122210223unvested
unwetted1238123unwetted
vatted104214733__vatted
vented104617923__vented
vested104217353__vested
vetoed10359823__vetoed
vetter93417643__vetter
vidette1167543vidette_
videttes1266333videttes
vignetted1443493vignetted
wetted103717023__wetted
whetted14256693_whetted
witted104216813wi__tted

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621706.47022590.7
3Display Results1701700.0602833.3
 (SQL Overall)1786911706.95325699.8
 
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.