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

177 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
ariettes841135(None) 
ariettas847391ariettas
ariette7312371ariette_
anisettes946672anisettes
aretes64425352ar_e_tes
arietta788902ariett_a
barbettes1348162barbettes
barrettes1149062barrettes
frisettes1295352frisettes
frizettes2193492frizettes
grisettes1094712grisettes
parietes10714542parie_tes
parkettes15137592parkettes
proettes10312762proettes
trientes82812122trientes
varieties1259202varieties
abetted1058323a_betted
abetter958323a_better
abetters1057173a_betters
acetates102013063a_cetates
acierates11310813acierates
agitates9310883agitates
aigrettes1046393aigrettes
airdates939723airdates
alienates9310683alienates
alienees8118653alienees
amirates101114793amirates
amities9317383ami_ties
animates101316423animates
anisette846773anisette_
anxieties1646263anxieties
appetites1347513appetites
arbutes939703ar_butes
arenes64928393ar_e_nes
arenites8917103arenites
areoles71016953ar_eoles
arete56031353ar_e_te_
argentites1147023argentites
argents84014853argent_s
aridities10911633aridities
ariels65119373arie__ls
arises65233803ari__ses
aristae7312533aristae_
aristas7413523ari_stas
aristate8312133aristate_
aristos7312373ari_stos
armets84918353arme_t_s
arnattos8144363arnattos
arnottos8163853arnottos
arpents93613083arpent_s
arrested939153arrested
arrestee849443arrestee
arrestees946233arrestees
arrester839253arrester
arresters948193arresters
arrests73312683arrest_s
arsenates979373arsenates
arsenites9149163arsenites
arteries8321483arteries
artistes83213343artistes
aviates10313063avi_ates
axites134913833axi__tes
baguettes12115393baguettes
barbette1249113barbette_
barites94322333bari__tes
barquettes2174753barquettes
barrette1039783barrette_
birettas1046513birettas
briolettes1243853briolettes
briquettes2183383briquettes
bristles101510433bristles
brittles10178653brittles
britts84813443bri_tt_s
brunettes1144583brunettes
burettes1048953burettes
casettes1039653casettes
cassettes1146703cassettes
corvettes1447433corvettes
creates95225203cr_eates
crinites10612763crinites
critter94113033cri_tter
critters103511323cri_tters
curettes1039313curettes
cuvettes1335323cuvettes
dinettes9310193dinettes
fouettes1137883fouettes
fretted113411853fr_etted
fretter103412753fr_etter
fretters113410303fr_etters
friezes19418913frie_zes
frigates12310933frigates
frisette1195483frisette_
frites94922483fri__tes
fritted113611333fri_tted
fritter103912773fri_tter
fritters113810783fri_tters
fritts94613193fri_tt_s
fritzes19329453fri_tzes
frizette2093503frizette_
fumettes1345773fumettes
gaieties9310183gaieties
galettes93111163galettes
garottes978283gar_ottes
garrottes1065483garrottes
gazettes18296863gazettes
genettes938303genettes
grieves1137323grie_ves
grisette994653grisette_
gristles9189203gristles
gritted94110903gri_tted
gritter83913353gri_tter
gritters94210633gri_tters
layettes1136263layettes
lunettes836753lunettes
maquettes2045913maquettes
marinates112516383marinates
marionettes1353003marionettes
mofettes1386083mofettes
moieties10311263moieties
musettes1037433musettes
navettes1136613navettes
noisettes946533noisettes
octettes1045533octettes
orientates1046043orientates
oriented937483oriented
orienter838313orienter
orienters937613orienters
orients7311583orient_s
palettes103112833palettes
pallettes1148803pallettes
palmettes1346883palmettes
pargetted1345663pargetted
parietals1146863parietals
parities10522973pari_ties
parkette14138023parkette_
paupiettes1442603paupiettes
pieties9419223_pieties
pipettes1237563pipettes
pretties10615133pr_etties
priested1138393priested
priestess1145293priestess
priests93810863priest_s
primates121515933primates
privates131812373privates
proette9312363proette_
quartettes1943793quartettes
raclettes1147013raclettes
rarities8316333rari_ties
rentes65431193_r_entes
reties65436193_r_eties
retted74826313_r_etted
rillettes946533_rillettes
rites54442553_ri__tes
ritter63822423_ri_tter
ritters74020623_ri_tters
ritzes154812943_ri_tzes
rivetted12226093_rivetted
rosettes8310343rosettes
rottes64524833_r_ottes
satieties939383satieties
satinettes1043923satinettes
serviettes1342903serviettes
syrettes1136963syrettes
toilettes946023toilettes
tonettes839203tonettes
tributes1047233tributes
trienes74118413trie_nes
ubieties1046913ubieties
urinates8314133urinates
variates111214983vari_ates
variegates1444043variegates
varietals1244443varietals
vedettes1265943vedettes
videttes1266333videttes
writes94420333wri__tes
writhes134811703wri_thes
written10336343wri_tten

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.406440125.6
2DLD Change Limit1461621777.26620115.9
3Display Results1771770.0762328.9
 (SQL Overall)1786911777.74823062.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.