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

192 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
ariette731237(None) 
arietta788901arietta
ariettes8411351ariettes
anisette846772anisette
arete56031352ar_e_te
ariettas847392ariettas
aristae7312522aristae
aristate8312122aristate
barbette1249112barbette
barrette1039782barrette
frisette1195482frisette
frizette2093502frizette
grisette994652grisette
parkette14138022parkette
proette9312362proette
abetted1058323a_betted
abetter958323a_better
acetate92514753a_cetate
acierate10311813acierate
aeriest73924053aeriest_
agitate8312063agitate
aigrette946833aigrette
airdate8311323airdate
airest63825263airest_
airiest74221013airiest_
alienate8311553alienate
alienee71013153alienee
amirate91115953amirate
animate91617213animate
anisettes946673anisettes
apiece10510083apie_ce
appetite1258493appetite
arbute8311043ar_bute
arcuate9311963arcuate
ardent73022613ardent_
areae55229743ar_e_ae
arene55329413ar_e_ne
arenite71017713arenite
areole61017283ar_eole
aretes64425353ar_etes
argent74023663argent_
argentite1047813argentite
argents84014853argents
aridest8316143aridest_
aridity11510113aridity
ariel55228973arie__l
ariels65119373arie_ls
aright103817663aright_
arillate8412993arillate
ariose64818723ari_ose
arise56436433ari__se
arista6415293ari_sta
aristas7413523aristas
aristo6414033ari_sto
aristos7312373aristos
armet76739453arme_t_
armets84918353arme_ts
arnatto7145073arnatto
arnotto7134733arnotto
arpent84822093arpent_
arpents93613083arpents
arrest63722633arrest_
arrested939153arrested
arrestee849433arrestee
arrester839253arrester
arrests73312683arrests
arsenate81010483arsenate
arsenite8119663arsenite
artiest73121993artiest_
artiste73813693artiste
aureate72515283aureate
aviate9315203avi_ate
axite125218253axi__te
baguette11105933baguette
barbettes1348163barbettes
barite84224813bari__te
barquette2064903barquette
barrettes1149063barrettes
biretta947243biretta
briolette1144183briolette
briquette2063673briquette
bristle91910103bristle
britt75732233bri_tt_
brittle9168603brittle
britts84813443bri_tts
brunette1044723brunette
burette939853burette
carinate103320243carinate
casette9310393casette
cassette1047813cassette
corvette1338093corvette
create85126373cr_eate
crinite9513633crinite
cristae9310603cristae
cristate10310593cristate
critter94113033cri_tter
curette939783curette
cuvette1235833cuvette
dinette8310013dinette
driest74722753driest_
fouette1038213fouette
fretted113411853fr_etted
fretter103412753fr_etter
fretty1249223fr_etty
frieze18378143frie_ze
frigate11311063frigate
frisettes1295353frisettes
fritt86129413fri_tt_
fritted113611333fri_tted
fritter103912773fri_tter
fritts94613193fri_tts
frizettes2193493frizettes
fumette1245523fumette
galette84212693galette
garotte868703gar_otte
garrotte965683garrotte
gazette17357363gazette
genette838863genette
grieve1047243grie_ve
grisettes1094713grisettes
gristle8169223gristle
gritted94110903gri_tted
gritter83913353gri_tter
gritty10338403gri_tty
layette1037133layette
lunette737483lunette
maquette1946113maquette
marinate103017783marinate
marionette1253673marionette
mofette1296773mofette
mozette1886773mozette
musette938433musette
navette1036983navette
noisette846313noisette
octette946423octette
orient6322533orient_
orientate946513orientate
oriented937483oriented
orienter838313orienter
orients7311583orients
palette93613983palette
pallette1039513pallette
palmette1247733palmette
pargetted1345663pargetted
parietal1048773parietal
parietes10714543parietes
parkettes15137593parkettes
paupiette1342603paupiette
pipette1137943pipette
pretty11510873pr_etty
priest84125423priest_
priested1138393priested
priests93810863priests
primate111516283primate
private121513263private
proettes10312763proettes
quartette1843963quartette
raclette1047643raclette
rente54733783_r_ente
rete44944133_r_e_te
retie55735303_r_etie
retted74826313_r_etted
rite45849453_ri__te
ritter63822413_ri_tter
rivetted12226083_rivetted
rosette7310373rosette
rotte54625933_r_otte
satinette944553satinette
serviette1242963serviette
strette7310763strette
syrette1037183syrette
toilette846683toilette
tonette7310373tonette
tribute937313tribute
triene64316383trie_ne
trientes82812123trientes
tristate8311023tristate
triste63818643tri_ste
trite54730033tri__te
urinate7315363urinate
variate101316433vari_ate
variegate1344093variegate
varietal1145613varietal
varieties1259203varieties
variety1337743varie_ty
vedette1166003vedette
vidette1167543vidette
wariest105122503wariest_
wriest94419713wriest_
write85522833wri__te
writhe125310703wri_the
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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271927.64017542.8
3Display Results1921920.0633047.6
 (SQL Overall)1786911927.85922737.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.